Repository navigation
Observatory DB — 2026-07-07
·
119 commits
to main
since this release
Observatory DB Merge Report
Date: 2026-07-07 17:30:07.104623
Output: observatory.db (1,181,724,672)
Sources
| Source | Status | Size | Tables | Total Rows |
|---|---|---|---|---|
| feed.db | merged | 91,107,328 | packages, package_versions, reverse_dependencies, package_version_history (4) | 586,671 |
| metadata.db | merged | 118,341,632 | check_status_history, cran_check_results, cran_check_details, cran_check_issues, authors, packages_enrichment, removal_reasons, package_news (8) | 489,172 |
| downloads-summary.db | merged | 1,687,552 | downloads_summary (1) | 24,960 |
| r2u-summary.db | merged | 2,056,192 | r2u_downloads_summary (1) | 29,174 |
| autoobs-downloads-summary.db | merged | 2,695,168 | autoobs_downloads_summary (1) | 27,711 |
| copr-downloads-summary.db | merged | 12,288 | copr_downloads_summary (1) | 5 |
| conda-forge-downloads-summary.db | merged | 466,944 | conda_forge_downloads_summary (1) | 3,867 |
| bioconda-downloads-summary.db | merged | 823,296 | bioconda_downloads_summary (1) | 5,160 |
| c2d4u-downloads-summary.db | merged | 843,776 | c2d4u_downloads_summary (1) | 7,565 |
| bioconductor-summary.db | merged | 692,224 | bioc_downloads_summary (1) | 6,299 |
| queue.db | merged | 41,148,416 | queue_snapshots, queue_history_daily, queue_stats (3) | 306,779 |
| bioconductor-metadata.db | merged | 6,459,392 | bioc_packages, bioc_authors, bioc_releases, bioc_view_edges (4) | 27,308 |
| cran-archive.db | merged | 3,883,008 | cran_archive, cran_archive_events (2) | 51,000 |
| cran-code-metrics.db | merged | 1,683,759,104 | cran_api_history, cran_code_summary, cran_functions, cran_call_edges (4) | 5,756,567 |
| bioc-code-metrics.db | skipped (file not found) | — | — | — |
| cran-coverage.db | merged | 8,630,272 | coverage_file, coverage_function, coverage_summary (3) | 139,931 |
| vcs-signals-summary.db | merged | 7,372,800 | vcs_signals_summary (1) | 15,726 |
Combined Tables
- authors: 62,036 rows
- autoobs_downloads_summary: 27,711 rows
- bioc_authors: 7,308 rows
- bioc_downloads_summary: 6,299 rows
- bioc_packages: 4,656 rows
- bioc_releases: 49 rows
- bioc_view_edges: 15,295 rows
- bioconda_downloads_summary: 5,160 rows
- c2d4u_downloads_summary: 7,565 rows
- check_status_history: 60,665 rows
- conda_forge_downloads_summary: 3,867 rows
- copr_downloads_summary: 5 rows
- copr_packages: 23,619 rows
- coverage_file: 21,065 rows
- coverage_function: 117,212 rows
- coverage_summary: 1,654 rows
- cran_api_history: 205,425 rows
- cran_archive: 8,591 rows
- cran_archive_events: 42,409 rows
- cran_call_edges: 2,972,912 rows
- cran_check_details: 27,500 rows
- cran_check_issues: 403 rows
- cran_check_results: 314,258 rows
- cran_code_summary: 205,425 rows
- cran_functions: 2,372,805 rows
- downloads_summary: 24,960 rows
- package_news: 94 rows
- package_version_history: 162,338 rows
- package_versions: 169,728 rows
- packages: 24,213 rows
- packages_enrichment: 24,216 rows
- packages_fts: 24,213 rows
- packages_fts_config: 1 rows
- packages_fts_data: 2,079 rows
- packages_fts_docsize: 24,213 rows
- packages_fts_idx: 1,894 rows
- queue_history_daily: 10,645 rows
- queue_snapshots: 296,084 rows
- queue_stats: 50 rows
- r2u_downloads_summary: 29,174 rows
- r_versions: 165 rows
- removal_reasons: 0 rows
- reverse_dependencies: 230,392 rows
- vcs_signals_summary: 15,726 rows
Total DB size: 1,181,724,672 bytes