johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Goa" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435925 | 3435925 | 2020-07-11 | India | Goa | 2368 | 12 | 1428 | 928 | 15.359682000000001 | 74.057396 | 2020-07-12 04:34:30 | Goa, India | ||
3237423 | 3237423 | 2020-07-10 | India | Goa | 2251 | 9 | 1347 | 895 | 15.359682000000001 | 74.057396 | 2020-07-11 04:34:26 | Goa, India | ||
1005408 | 1005408 | 2020-07-09 | India | Goa | 2151 | 9 | 1273 | 869 | 15.359682000000001 | 74.057396 | 2020-07-10 04:34:24 | Goa, India | ||
2222624 | 2222624 | 2020-07-08 | India | Goa | 2039 | 8 | 1207 | 824 | 15.359682000000001 | 74.057396 | 2020-07-09 04:34:23 | Goa, India | ||
887233 | 887233 | 2020-07-07 | India | Goa | 1903 | 8 | 1156 | 739 | 15.359682000000001 | 74.057396 | 2020-07-08 05:33:48 | Goa, India | ||
2684793 | 2684793 | 2020-07-06 | India | Goa | 1813 | 7 | 1061 | 745 | 15.359682000000001 | 74.057396 | 2020-07-07 04:34:00 | Goa, India | ||
415258 | 415258 | 2020-07-05 | India | Goa | 1761 | 7 | 936 | 818 | 15.359682000000001 | 74.057396 | 2020-07-06 04:33:57 | Goa, India | ||
529820 | 529820 | 2020-07-04 | India | Goa | 1684 | 6 | 825 | 853 | 15.359682000000001 | 74.057396 | 2020-07-05 04:33:46 | Goa, India | ||
2234481 | 2234481 | 2020-07-03 | India | Goa | 1482 | 4 | 734 | 744 | 15.359682000000001 | 74.057396 | 2020-07-04 04:33:51 | Goa, India | ||
3045275 | 3045275 | 2020-07-02 | India | Goa | 1482 | 4 | 734 | 744 | 15.359682 | 74.057396 | 2020-07-03 04:33:54 | Goa, India | ||
302966 | 302966 | 2020-07-01 | India | Goa | 1387 | 4 | 670 | 713 | 15.359682000000001 | 74.057396 | 2020-07-02 04:33:46 | Goa, India | ||
2974344 | 2974344 | 2020-06-30 | India | Goa | 1315 | 3 | 596 | 716 | 15.359682000000001 | 74.057396 | 2020-07-01 04:33:52 | Goa, India | ||
2632821 | 2632821 | 2020-06-29 | India | Goa | 1198 | 3 | 478 | 717 | 15.359682 | 74.057396 | 2020-06-30 04:33:48 | Goa, India | ||
2306384 | 2306384 | 2020-06-28 | India | Goa | 1198 | 3 | 478 | 717 | 15.359682000000001 | 74.057396 | 2020-06-29 04:33:44 | Goa, India | ||
2039719 | 2039719 | 2020-06-27 | India | Goa | 1128 | 2 | 420 | 706 | 15.359682000000001 | 74.057396 | 2020-06-28 04:34:04 | Goa, India | ||
1136000 | 1136000 | 2020-06-26 | India | Goa | 1039 | 2 | 370 | 667 | 15.359682000000001 | 74.057396 | 2020-06-27 04:33:35 | Goa, India | ||
2624987 | 2624987 | 2020-06-25 | India | Goa | 995 | 2 | 335 | 658 | 15.359682000000001 | 74.057396 | 2020-06-26 04:33:43 | Goa, India | ||
2700627 | 2700627 | 2020-06-24 | India | Goa | 951 | 2 | 289 | 660 | 15.359682000000001 | 74.057396 | 2020-06-25 05:26:54 | Goa, India | ||
1522312 | 1522312 | 2020-06-23 | India | Goa | 909 | 1 | 205 | 703 | 15.359682000000001 | 74.057396 | 2020-06-24 04:33:28 | Goa, India | ||
1510506 | 1510506 | 2020-06-22 | India | Goa | 864 | 1 | 152 | 711 | 15.359682000000001 | 74.057396 | 2020-06-23 04:33:22 | Goa, India | ||
3249245 | 3249245 | 2020-06-21 | India | Goa | 754 | 0 | 129 | 625 | 15.359682000000001 | 74.057396 | 2020-06-22 04:33:20 | Goa, India | ||
2437838 | 2437838 | 2020-06-20 | India | Goa | 754 | 0 | 129 | 625 | 15.359682000000001 | 74.057396 | 2020-06-21 04:33:19 | Goa, India | ||
1691416 | 1691416 | 2020-06-19 | India | Goa | 725 | 0 | 118 | 607 | 15.359682000000001 | 74.057396 | 2020-06-20 04:33:19 | Goa, India | ||
3682565 | 3682565 | 2020-06-18 | India | Goa | 705 | 0 | 109 | 596 | 15.359682000000001 | 74.057396 | 2020-06-19 04:33:17 | Goa, India | ||
1195768 | 1195768 | 2020-06-17 | India | Goa | 656 | 0 | 96 | 560 | 15.359682000000001 | 74.057396 | 2020-06-18 04:33:18 | Goa, India | ||
2386531 | 2386531 | 2020-06-16 | India | Goa | 629 | 0 | 85 | 544 | 15.359682000000001 | 74.057396 | 2020-06-17 04:33:21 | Goa, India | ||
287094 | 287094 | 2020-06-15 | India | Goa | 592 | 0 | 85 | 507 | 15.359682000000001 | 74.057396 | 2020-06-16 04:33:09 | Goa, India | ||
1837045 | 1837045 | 2020-06-14 | India | Goa | 523 | 0 | 70 | 453 | 15.359682000000001 | 74.057396 | 2020-06-15 03:33:14 | Goa, India | ||
3061097 | 3061097 | 2020-06-13 | India | Goa | 463 | 0 | 69 | 394 | 15.359682000000001 | 74.057396 | 2020-06-14 03:33:15 | Goa, India | ||
737417 | 737417 | 2020-06-12 | India | Goa | 417 | 0 | 67 | 350 | 15.359682000000001 | 74.057396 | 2020-06-13 03:33:14 | Goa, India | ||
1273387 | 1273387 | 2020-06-11 | India | Goa | 417 | 0 | 67 | 350 | 15.359682000000001 | 74.057396 | 2020-06-12 05:09:52 | Goa, India | ||
2863830 | 2863830 | 2020-06-10 | India | Goa | 359 | 0 | 67 | 292 | 15.359682 | 74.057396 | 2020-06-11 03:33:41 | Goa, 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]);