johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
787 rows where confirmed = 550 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754890 | 2754890 | 2022-12-29 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-30 04:21:04 | Worth, Missouri, US | |
1075896 | 1075896 | 2022-12-28 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-29 04:21:01 | Worth, Missouri, US | |
329893 | 329893 | 2022-12-27 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-28 04:21:04 | Worth, Missouri, US | |
3755874 | 3755874 | 2022-10-13 | US | North Dakota | Divide | 38023 | 550 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-10-14 04:22:28 | Divide, North Dakota, US | |
2636853 | 2636853 | 2022-09-05 | US | Texas | Irion | 48235 | 550 | 3 | 0 | 31.30375559 | -100.982439 | 2022-09-06 04:21:02 | Irion, Texas, US | |
2990417 | 2990417 | 2022-09-04 | US | Texas | Irion | 48235 | 550 | 3 | 0 | 31.30375559 | -100.982439 | 2022-09-05 04:21:01 | Irion, Texas, US | |
2716102 | 2716102 | 2022-09-03 | US | Texas | Irion | 48235 | 550 | 3 | 0 | 31.30375559 | -100.982439 | 2022-09-04 04:21:22 | Irion, Texas, US | |
1396807 | 1396807 | 2022-09-02 | US | Texas | Irion | 48235 | 550 | 3 | 0 | 31.30375559 | -100.982439 | 2022-09-03 04:21:04 | Irion, Texas, US | |
1682612 | 1682612 | 2022-08-29 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-30 04:21:03 | Perkins, Nebraska, US | |
1879096 | 1879096 | 2022-08-28 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-29 04:21:06 | Perkins, Nebraska, US | |
2098223 | 2098223 | 2022-08-27 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-28 04:21:02 | Perkins, Nebraska, US | |
1534038 | 1534038 | 2022-08-26 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-27 04:20:57 | Perkins, Nebraska, US | |
2830925 | 2830925 | 2022-08-25 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-26 04:21:02 | Perkins, Nebraska, US | |
2325458 | 2325458 | 2022-08-24 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-25 04:21:13 | Perkins, Nebraska, US | |
1252867 | 1252867 | 2022-08-23 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-24 04:20:46 | Perkins, Nebraska, US | |
2854971 | 2854971 | 2022-08-22 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-23 04:20:56 | Perkins, Nebraska, US | |
2404943 | 2404943 | 2022-08-21 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-22 04:20:38 | Perkins, Nebraska, US | |
3800021 | 3800021 | 2022-08-20 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-21 04:20:44 | Perkins, Nebraska, US | |
2365607 | 2365607 | 2022-08-19 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-20 04:21:01 | Perkins, Nebraska, US | |
1163576 | 1163576 | 2022-08-18 | US | North Dakota | Kidder | 38043 | 550 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-08-19 04:20:54 | Kidder, North Dakota, US | |
1163278 | 1163278 | 2022-08-18 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-19 04:20:54 | Perkins, Nebraska, US | |
3952900 | 3952900 | 2022-08-17 | US | North Dakota | Kidder | 38043 | 550 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-08-18 04:21:11 | Kidder, North Dakota, US | |
3952602 | 3952602 | 2022-08-17 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-18 04:21:11 | Perkins, Nebraska, US | |
993402 | 993402 | 2022-08-16 | US | North Dakota | Kidder | 38043 | 550 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-08-17 04:20:59 | Kidder, North Dakota, US | |
993104 | 993104 | 2022-08-16 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-17 04:20:59 | Perkins, Nebraska, US | |
2496441 | 2496441 | 2022-08-15 | US | North Dakota | Kidder | 38043 | 550 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-08-16 04:20:58 | Kidder, North Dakota, US | |
2496143 | 2496143 | 2022-08-15 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-16 04:20:58 | Perkins, Nebraska, US | |
3649693 | 3649693 | 2022-08-14 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-15 04:20:59 | Perkins, Nebraska, US | |
1970699 | 1970699 | 2022-08-13 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-14 04:20:55 | Perkins, Nebraska, US | |
2890508 | 2890508 | 2022-08-12 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-13 04:20:52 | Perkins, Nebraska, US | |
3910113 | 3910113 | 2022-08-11 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-12 04:20:54 | Perkins, Nebraska, US | |
1348430 | 1348430 | 2022-08-10 | US | Nebraska | Perkins | 31135 | 550 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-08-11 04:20:49 | Perkins, Nebraska, US | |
3620300 | 3620300 | 2022-08-01 | US | Texas | Schleicher | 48413 | 550 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-02 04:20:53 | Schleicher, Texas, US | |
1488949 | 1488949 | 2022-07-26 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-27 04:21:04 | Wichita, Kansas, US | |
2595395 | 2595395 | 2022-07-25 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-26 04:20:58 | Wichita, Kansas, US | |
897510 | 897510 | 2022-07-24 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-25 04:20:51 | Wichita, Kansas, US | |
92504 | 92504 | 2022-07-23 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-24 04:20:47 | Wichita, Kansas, US | |
901526 | 901526 | 2022-07-22 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-23 04:20:53 | Wichita, Kansas, US | |
671662 | 671662 | 2022-07-21 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-22 04:21:15 | Wichita, Kansas, US | |
1609625 | 1609625 | 2022-07-20 | US | Kansas | Wichita | 20203 | 550 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-07-21 04:21:10 | Wichita, Kansas, US | |
2740815 | 2740815 | 2022-07-07 | China | Macau | 550 | 2 | 0 | 22.1667 | 113.55 | 2022-07-08 04:20:56 | Macau, China | |||
3968696 | 3968696 | 2022-07-05 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-06 04:20:58 | Lincoln, Nevada, US | |
3080207 | 3080207 | 2022-07-04 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-05 04:20:45 | Lincoln, Nevada, US | |
1769489 | 1769489 | 2022-07-03 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-04 04:20:54 | Lincoln, Nevada, US | |
3367475 | 3367475 | 2022-07-02 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-03 04:20:59 | Lincoln, Nevada, US | |
595804 | 595804 | 2022-07-01 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-02 04:21:16 | Lincoln, Nevada, US | |
3942205 | 3942205 | 2022-06-30 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-01 04:21:10 | Lincoln, Nevada, US | |
2492163 | 2492163 | 2022-06-29 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-30 04:21:01 | Lincoln, Nevada, US | |
2241545 | 2241545 | 2022-06-28 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-29 04:20:59 | Lincoln, Nevada, US | |
2149787 | 2149787 | 2022-06-27 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-28 04:20:58 | Lincoln, Nevada, US | |
2149727 | 2149727 | 2022-06-27 | US | Nebraska | Hitchcock | 31087 | 550 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-06-28 04:20:58 | Hitchcock, Nebraska, US | |
2149715 | 2149715 | 2022-06-27 | US | Nebraska | Frontier | 31063 | 550 | 3 | 0 | 40.52993007 | -100.3924658 | 2022-06-28 04:20:58 | Frontier, Nebraska, US | |
477588 | 477588 | 2022-06-26 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-27 04:21:00 | Lincoln, Nevada, US | |
477528 | 477528 | 2022-06-26 | US | Nebraska | Hitchcock | 31087 | 550 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-06-27 04:21:00 | Hitchcock, Nebraska, US | |
477516 | 477516 | 2022-06-26 | US | Nebraska | Frontier | 31063 | 550 | 3 | 0 | 40.52993007 | -100.3924658 | 2022-06-27 04:21:00 | Frontier, Nebraska, US | |
940963 | 940963 | 2022-06-25 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-26 04:21:02 | Lincoln, Nevada, US | |
940903 | 940903 | 2022-06-25 | US | Nebraska | Hitchcock | 31087 | 550 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-06-26 04:21:02 | Hitchcock, Nebraska, US | |
940891 | 940891 | 2022-06-25 | US | Nebraska | Frontier | 31063 | 550 | 3 | 0 | 40.52993007 | -100.3924658 | 2022-06-26 04:21:02 | Frontier, Nebraska, US | |
3348783 | 3348783 | 2022-06-24 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-25 04:20:57 | Lincoln, Nevada, US | |
1650524 | 1650524 | 2022-06-23 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-24 04:20:58 | Lincoln, Nevada, US | |
2189759 | 2189759 | 2022-06-22 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-23 04:20:55 | Lincoln, Nevada, US | |
168190 | 168190 | 2022-06-21 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-22 04:20:54 | Lincoln, Nevada, US | |
1765473 | 1765473 | 2022-06-20 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-21 04:20:56 | Lincoln, Nevada, US | |
3271659 | 3271659 | 2022-06-19 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-20 04:21:01 | Lincoln, Nevada, US | |
3399571 | 3399571 | 2022-06-18 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-19 04:20:51 | Lincoln, Nevada, US | |
2313448 | 2313448 | 2022-06-17 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-18 04:21:10 | Lincoln, Nevada, US | |
560952 | 560952 | 2022-06-16 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-17 04:20:56 | Lincoln, Nevada, US | |
3984754 | 3984754 | 2022-06-15 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-06-16 04:20:55 | Lincoln, Nevada, US | |
3001451 | 3001451 | 2022-05-24 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-25 04:20:56 | Lincoln, Nevada, US | |
3595172 | 3595172 | 2022-05-23 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-24 04:20:57 | Lincoln, Nevada, US | |
1111720 | 1111720 | 2022-05-21 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-22 04:20:52 | Lincoln, Nevada, US | |
1171344 | 1171344 | 2022-05-20 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-21 04:20:58 | Lincoln, Nevada, US | |
3898107 | 3898107 | 2022-05-19 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-20 04:20:57 | Lincoln, Nevada, US | |
1186891 | 1186891 | 2022-05-18 | US | Nevada | Lincoln | 32017 | 550 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-05-19 04:20:54 | Lincoln, Nevada, US | |
3584788 | 3584788 | 2022-05-17 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-18 04:20:50 | Lincoln, Nevada, US | |
1505745 | 1505745 | 2022-05-16 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-17 04:20:59 | Lincoln, Nevada, US | |
2086104 | 2086104 | 2022-05-15 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-16 04:20:47 | Lincoln, Nevada, US | |
3356814 | 3356814 | 2022-05-14 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-15 04:20:53 | Lincoln, Nevada, US | |
660459 | 660459 | 2022-05-13 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-14 04:20:48 | Lincoln, Nevada, US | |
2535542 | 2535542 | 2022-05-12 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-13 04:20:51 | Lincoln, Nevada, US | |
3446988 | 3446988 | 2022-05-11 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-05-12 04:20:54 | Lincoln, Nevada, US | |
2031192 | 2031192 | 2022-04-24 | US | North Dakota | Renville | 38075 | 550 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-04-25 04:20:56 | Renville, North Dakota, US | |
748767 | 748767 | 2022-04-23 | US | North Dakota | Renville | 38075 | 550 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-04-24 04:20:56 | Renville, North Dakota, US | |
3439252 | 3439252 | 2022-04-22 | US | North Dakota | Renville | 38075 | 550 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-04-23 04:20:50 | Renville, North Dakota, US | |
1950658 | 1950658 | 2022-04-12 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-13 04:21:03 | Lincoln, Nevada, US | |
3208411 | 3208411 | 2022-04-11 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-12 04:20:49 | Lincoln, Nevada, US | |
1578297 | 1578297 | 2022-04-10 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-11 04:21:02 | Lincoln, Nevada, US | |
1654539 | 1654539 | 2022-04-09 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-10 04:20:52 | Lincoln, Nevada, US | |
2117861 | 2117861 | 2022-04-08 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-09 04:20:42 | Lincoln, Nevada, US | |
3322385 | 3322385 | 2022-04-07 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-08 04:20:48 | Lincoln, Nevada, US | |
2802921 | 2802921 | 2022-04-06 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-07 04:20:53 | Lincoln, Nevada, US | |
3869690 | 3869690 | 2022-04-05 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-06 04:20:49 | Lincoln, Nevada, US | |
2751032 | 2751032 | 2022-04-04 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-05 04:20:48 | Lincoln, Nevada, US | |
3732378 | 3732378 | 2022-04-03 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-04 04:20:51 | Lincoln, Nevada, US | |
501813 | 501813 | 2022-04-02 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-03 04:20:48 | Lincoln, Nevada, US | |
3352798 | 3352798 | 2022-04-01 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-02 04:20:47 | Lincoln, Nevada, US | |
1542103 | 1542103 | 2022-03-31 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-04-01 04:20:28 | Lincoln, Nevada, US | |
2480116 | 2480116 | 2022-03-30 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-03-31 04:20:56 | Lincoln, Nevada, US | |
160157 | 160157 | 2022-03-29 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-03-30 04:20:45 | Lincoln, Nevada, US | |
1438728 | 1438728 | 2022-03-28 | US | Nevada | Lincoln | 32017 | 550 | 7 | 0 | 37.64268459 | -114.8790388 | 2022-03-29 04:20:46 | Lincoln, Nevada, US |
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]);