johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Delhi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435898 | 3435898 | 2020-07-11 | India | Delhi | 110921 | 3334 | 87692 | 19895 | 28.646519 | 77.10898 | 2020-07-12 04:34:30 | Delhi, India | ||
3237396 | 3237396 | 2020-07-10 | India | Delhi | 109140 | 3300 | 84694 | 21146 | 28.646519 | 77.10898 | 2020-07-11 04:34:26 | Delhi, India | ||
1005381 | 1005381 | 2020-07-09 | India | Delhi | 107051 | 3258 | 82226 | 21567 | 28.646519 | 77.10898 | 2020-07-10 04:34:24 | Delhi, India | ||
2222597 | 2222597 | 2020-07-08 | India | Delhi | 104864 | 3213 | 78199 | 23452 | 28.646519 | 77.10898 | 2020-07-09 04:34:23 | Delhi, India | ||
887206 | 887206 | 2020-07-07 | India | Delhi | 102831 | 3165 | 74217 | 25449 | 28.646519 | 77.10898 | 2020-07-08 05:33:48 | Delhi, India | ||
2684766 | 2684766 | 2020-07-06 | India | Delhi | 100823 | 3115 | 72088 | 25620 | 28.646519 | 77.10898 | 2020-07-07 04:34:00 | Delhi, India | ||
415231 | 415231 | 2020-07-05 | India | Delhi | 99444 | 3067 | 71339 | 25038 | 28.646519 | 77.10898 | 2020-07-06 04:33:57 | Delhi, India | ||
529793 | 529793 | 2020-07-04 | India | Delhi | 97200 | 3004 | 68256 | 25940 | 28.646519 | 77.10898 | 2020-07-05 04:33:46 | Delhi, India | ||
2234454 | 2234454 | 2020-07-03 | India | Delhi | 94695 | 2923 | 65624 | 26148 | 28.646519 | 77.10898 | 2020-07-04 04:33:51 | Delhi, India | ||
3045248 | 3045248 | 2020-07-02 | India | Delhi | 92175 | 2864 | 63007 | 26304 | 28.646519 | 77.10898 | 2020-07-03 04:33:54 | Delhi, India | ||
302939 | 302939 | 2020-07-01 | India | Delhi | 89802 | 2803 | 59992 | 27007 | 28.646519 | 77.10898 | 2020-07-02 04:33:46 | Delhi, India | ||
2974317 | 2974317 | 2020-06-30 | India | Delhi | 87360 | 2742 | 58348 | 26270 | 28.646519 | 77.10898 | 2020-07-01 04:33:52 | Delhi, India | ||
2632794 | 2632794 | 2020-06-29 | India | Delhi | 85161 | 2680 | 56235 | 26246 | 28.646519 | 77.10898 | 2020-06-30 04:33:48 | Delhi, India | ||
2306357 | 2306357 | 2020-06-28 | India | Delhi | 83077 | 2623 | 52607 | 27847 | 28.646519 | 77.10898 | 2020-06-29 04:33:44 | Delhi, India | ||
2039692 | 2039692 | 2020-06-27 | India | Delhi | 80188 | 2558 | 49301 | 28329 | 28.646519 | 77.10898 | 2020-06-28 04:34:04 | Delhi, India | ||
1135973 | 1135973 | 2020-06-26 | India | Delhi | 77240 | 2492 | 47091 | 27657 | 28.646519 | 77.10898 | 2020-06-27 04:33:35 | Delhi, India | ||
2624960 | 2624960 | 2020-06-25 | India | Delhi | 73780 | 2429 | 44765 | 26586 | 28.646519 | 77.10898 | 2020-06-26 04:33:43 | Delhi, India | ||
2700600 | 2700600 | 2020-06-24 | India | Delhi | 70390 | 2365 | 41437 | 26588 | 28.646519 | 77.10898 | 2020-06-25 05:26:54 | Delhi, India | ||
1522285 | 1522285 | 2020-06-23 | India | Delhi | 66602 | 2301 | 39313 | 24988 | 28.646519 | 77.10898 | 2020-06-24 04:33:28 | Delhi, India | ||
1510479 | 1510479 | 2020-06-22 | India | Delhi | 62655 | 2233 | 36602 | 23820 | 28.646519 | 77.10898 | 2020-06-23 04:33:22 | Delhi, India | ||
3249218 | 3249218 | 2020-06-21 | India | Delhi | 59746 | 2175 | 33013 | 24558 | 28.646519 | 77.10898 | 2020-06-22 04:33:20 | Delhi, India | ||
2437811 | 2437811 | 2020-06-20 | India | Delhi | 56746 | 2112 | 31294 | 23340 | 28.646519 | 77.10898 | 2020-06-21 04:33:19 | Delhi, India | ||
1691389 | 1691389 | 2020-06-19 | India | Delhi | 53116 | 2035 | 23569 | 27512 | 28.646519 | 77.10898 | 2020-06-20 04:33:19 | Delhi, India | ||
3682538 | 3682538 | 2020-06-18 | India | Delhi | 49979 | 1969 | 21341 | 26669 | 28.646519 | 77.10898 | 2020-06-19 04:33:17 | Delhi, India | ||
1195741 | 1195741 | 2020-06-17 | India | Delhi | 47102 | 1904 | 17457 | 27741 | 28.646519 | 77.10898 | 2020-06-18 04:33:18 | Delhi, India | ||
2386504 | 2386504 | 2020-06-16 | India | Delhi | 44688 | 1837 | 16500 | 26351 | 28.646519 | 77.10898 | 2020-06-17 04:33:21 | Delhi, India | ||
287067 | 287067 | 2020-06-15 | India | Delhi | 42829 | 1400 | 16427 | 25002 | 28.646519 | 77.10898 | 2020-06-16 04:33:09 | Delhi, India | ||
1837018 | 1837018 | 2020-06-14 | India | Delhi | 38958 | 1271 | 14945 | 22742 | 28.646519 | 77.10898 | 2020-06-15 03:33:14 | Delhi, India | ||
3061070 | 3061070 | 2020-06-13 | India | Delhi | 36824 | 1214 | 13398 | 22212 | 28.646519 | 77.10898 | 2020-06-14 03:33:15 | Delhi, India | ||
737390 | 737390 | 2020-06-12 | India | Delhi | 34687 | 1085 | 12731 | 20871 | 28.646519 | 77.10898 | 2020-06-13 03:33:14 | Delhi, India | ||
1273360 | 1273360 | 2020-06-11 | India | Delhi | 34687 | 1085 | 12731 | 20871 | 28.646519 | 77.10898 | 2020-06-12 05:09:52 | Delhi, India | ||
2863804 | 2863804 | 2020-06-10 | India | Delhi | 31309 | 905 | 11861 | 18543 | 28.646519 | 77.10898 | 2020-06-11 03:33:41 | Delhi, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);