johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
852 rows where confirmed = 424 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- US 814
- Japan 11
- Canada 3
- China 3
- Colombia 3
- Russia 3
- Ukraine 3
- France 2
- Uruguay 2
- Armenia 1
- Bangladesh 1
- Bhutan 1
- Chile 1
- El Salvador 1
- Mali 1
- Mozambique 1
- Papua New Guinea 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176223 | 3176223 | 2022-12-19 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-20 04:21:04 | Steele, North Dakota, US | |
1630740 | 1630740 | 2022-12-18 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-19 04:21:03 | Steele, North Dakota, US | |
506119 | 506119 | 2022-12-17 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-18 04:21:03 | Steele, North Dakota, US | |
3326691 | 3326691 | 2022-12-16 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-17 04:21:04 | Steele, North Dakota, US | |
545203 | 545203 | 2022-12-15 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-16 04:21:01 | Steele, North Dakota, US | |
350731 | 350731 | 2022-12-14 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-15 04:20:58 | Steele, North Dakota, US | |
310319 | 310319 | 2022-12-13 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-14 04:21:04 | Steele, North Dakota, US | |
1151380 | 1151380 | 2022-12-12 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-13 04:21:01 | Steele, North Dakota, US | |
871234 | 871234 | 2022-12-11 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-12 04:21:01 | Steele, North Dakota, US | |
259764 | 259764 | 2022-12-10 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-11 04:20:50 | Steele, North Dakota, US | |
3938478 | 3938478 | 2022-12-09 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-10 04:21:02 | Steele, North Dakota, US | |
3379810 | 3379810 | 2022-12-08 | US | North Dakota | Steele | 38091 | 424 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-09 04:21:05 | Steele, North Dakota, US | |
3988641 | 3988641 | 2022-09-15 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-16 04:21:19 | McCone, Montana, US | |
1891158 | 1891158 | 2022-09-14 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-15 04:21:02 | McCone, Montana, US | |
374213 | 374213 | 2022-09-13 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-14 04:20:44 | McCone, Montana, US | |
2396815 | 2396815 | 2022-09-12 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-13 04:20:57 | McCone, Montana, US | |
3767893 | 3767893 | 2022-09-11 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-12 04:20:58 | McCone, Montana, US | |
3826468 | 3826468 | 2022-09-10 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-11 04:20:50 | McCone, Montana, US | |
964925 | 964925 | 2022-09-09 | US | Montana | McCone | 30055 | 424 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-10 04:21:10 | McCone, Montana, US | |
3430949 | 3430949 | 2022-07-14 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-15 04:20:53 | Worth, Missouri, US | |
3111469 | 3111469 | 2022-07-13 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-14 04:20:57 | Worth, Missouri, US | |
631892 | 631892 | 2022-07-12 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-13 04:20:58 | Worth, Missouri, US | |
1213536 | 1213536 | 2022-07-11 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-12 04:20:51 | Worth, Missouri, US | |
2791018 | 2791018 | 2022-07-10 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-11 04:20:46 | Worth, Missouri, US | |
143971 | 143971 | 2022-07-09 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-10 04:20:54 | Worth, Missouri, US | |
1419071 | 1419071 | 2022-07-08 | US | Missouri | Worth | 29227 | 424 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-07-09 04:20:59 | Worth, Missouri, US | |
3966359 | 3966359 | 2022-07-05 | China | Shanxi | 424 | 0 | 0 | 37.5777 | 112.2922 | 2022-07-06 04:20:58 | Shanxi, China | |||
3077870 | 3077870 | 2022-07-04 | China | Shanxi | 424 | 0 | 0 | 37.5777 | 112.2922 | 2022-07-05 04:20:45 | Shanxi, China | |||
3135660 | 3135660 | 2022-06-03 | US | Nebraska | Pawnee | 31133 | 424 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-06-04 04:20:58 | Pawnee, Nebraska, US | |
3580735 | 3580735 | 2022-06-02 | US | Nebraska | Pawnee | 31133 | 424 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-06-03 04:20:58 | Pawnee, Nebraska, US | |
973108 | 973108 | 2022-06-01 | US | New Mexico | Catron | 35003 | 424 | 15 | 0 | 33.91514144 | -108.4046587 | 2022-06-02 05:20:39 | Catron, New Mexico, US | |
973028 | 973028 | 2022-06-01 | US | Nebraska | Pawnee | 31133 | 424 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-06-02 05:20:39 | Pawnee, Nebraska, US | |
231335 | 231335 | 2022-05-31 | US | Nebraska | Pawnee | 31133 | 424 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-06-01 04:20:55 | Pawnee, Nebraska, US | |
230580 | 230580 | 2022-05-31 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-06-01 04:20:55 | Stanton, Kansas, US | |
230093 | 230093 | 2022-05-31 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-06-01 04:20:55 | Quitman, Georgia, US | |
3187345 | 3187345 | 2022-05-30 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-31 04:20:51 | Stanton, Kansas, US | |
3186858 | 3186858 | 2022-05-30 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-31 04:20:51 | Quitman, Georgia, US | |
3199494 | 3199494 | 2022-05-29 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-30 04:20:50 | Stanton, Kansas, US | |
3199007 | 3199007 | 2022-05-29 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-30 04:20:50 | Quitman, Georgia, US | |
2726372 | 2726372 | 2022-05-28 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-29 04:20:53 | Stanton, Kansas, US | |
2725885 | 2725885 | 2022-05-28 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-29 04:20:53 | Quitman, Georgia, US | |
1315553 | 1315553 | 2022-05-27 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-28 04:21:07 | Stanton, Kansas, US | |
1315066 | 1315066 | 2022-05-27 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-28 04:21:07 | Quitman, Georgia, US | |
1851345 | 1851345 | 2022-05-26 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-27 04:20:56 | Stanton, Kansas, US | |
1850858 | 1850858 | 2022-05-26 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-27 04:20:56 | Quitman, Georgia, US | |
2049221 | 2049221 | 2022-05-25 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-26 04:20:50 | Stanton, Kansas, US | |
2048734 | 2048734 | 2022-05-25 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-26 04:20:50 | Quitman, Georgia, US | |
3000172 | 3000172 | 2022-05-24 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-25 04:20:56 | Quitman, Georgia, US | |
3593893 | 3593893 | 2022-05-23 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-24 04:20:57 | Quitman, Georgia, US | |
623232 | 623232 | 2022-05-22 | US | Kansas | Stanton | 20187 | 424 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-05-26 04:20:50 | Stanton, Kansas, US | |
622745 | 622745 | 2022-05-22 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-26 04:20:50 | Quitman, Georgia, US | |
1110441 | 1110441 | 2022-05-21 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-22 04:20:52 | Quitman, Georgia, US | |
1170065 | 1170065 | 2022-05-20 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-21 04:20:58 | Quitman, Georgia, US | |
3896828 | 3896828 | 2022-05-19 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-20 04:20:57 | Quitman, Georgia, US | |
1185612 | 1185612 | 2022-05-18 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-19 04:20:54 | Quitman, Georgia, US | |
1573002 | 1573002 | 2022-05-03 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-04 04:20:59 | Quitman, Georgia, US | |
464262 | 464262 | 2022-05-02 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-03 04:21:00 | Quitman, Georgia, US | |
3916901 | 3916901 | 2022-05-01 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-02 04:21:10 | Quitman, Georgia, US | |
2841705 | 2841705 | 2022-04-30 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-05-01 04:20:57 | Quitman, Georgia, US | |
1158018 | 1158018 | 2022-04-29 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-30 04:21:05 | Quitman, Georgia, US | |
1697200 | 1697200 | 2022-04-28 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-29 04:20:59 | Quitman, Georgia, US | |
3852683 | 3852683 | 2022-04-27 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-28 04:20:47 | Quitman, Georgia, US | |
1327113 | 1327113 | 2022-04-26 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-27 04:20:52 | Quitman, Georgia, US | |
3723067 | 3723067 | 2022-04-25 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-26 04:20:51 | Quitman, Georgia, US | |
2029635 | 2029635 | 2022-04-24 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-25 04:20:56 | Quitman, Georgia, US | |
747210 | 747210 | 2022-04-23 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-24 04:20:56 | Quitman, Georgia, US | |
3437695 | 3437695 | 2022-04-22 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-23 04:20:50 | Quitman, Georgia, US | |
2893280 | 2893280 | 2022-04-21 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-22 04:20:45 | Quitman, Georgia, US | |
2308152 | 2308152 | 2022-04-20 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-21 04:20:46 | Quitman, Georgia, US | |
3321106 | 3321106 | 2022-04-07 | US | Georgia | Quitman | 13239 | 424 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-08 04:20:48 | Quitman, Georgia, US | |
922758 | 922758 | 2022-03-08 | US | Texas | Dickens | 48125 | 424 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-03-09 04:20:59 | Dickens, Texas, US | |
1551045 | 1551045 | 2022-03-07 | US | Texas | Dickens | 48125 | 424 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-03-08 04:20:54 | Dickens, Texas, US | |
2202714 | 2202714 | 2022-03-06 | US | Texas | Dickens | 48125 | 424 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-03-07 04:20:47 | Dickens, Texas, US | |
2095171 | 2095171 | 2022-03-05 | US | Texas | Dickens | 48125 | 424 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-03-06 04:20:49 | Dickens, Texas, US | |
945725 | 945725 | 2022-02-28 | US | South Dakota | McPherson | 46089 | 424 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-03-01 04:21:09 | McPherson, South Dakota, US | |
2735916 | 2735916 | 2022-02-27 | US | South Dakota | McPherson | 46089 | 424 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-02-28 04:21:05 | McPherson, South Dakota, US | |
3049069 | 3049069 | 2022-02-26 | US | South Dakota | McPherson | 46089 | 424 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-02-27 04:21:04 | McPherson, South Dakota, US | |
577724 | 577724 | 2022-02-25 | US | South Dakota | McPherson | 46089 | 424 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-02-26 04:21:12 | McPherson, South Dakota, US | |
1514300 | 1514300 | 2022-02-24 | US | South Dakota | McPherson | 46089 | 424 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-02-25 04:21:11 | McPherson, South Dakota, US | |
3822847 | 3822847 | 2022-02-16 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-17 04:20:56 | Logan, North Dakota, US | |
3674061 | 3674061 | 2022-02-15 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-16 04:21:10 | Logan, North Dakota, US | |
2644162 | 2644162 | 2022-02-14 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-15 04:21:09 | Logan, North Dakota, US | |
2643106 | 2643106 | 2022-02-14 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-15 04:21:09 | Stanton, Kansas, US | |
188479 | 188479 | 2022-02-13 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-14 04:20:51 | Logan, North Dakota, US | |
187423 | 187423 | 2022-02-13 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-14 04:20:51 | Stanton, Kansas, US | |
318325 | 318325 | 2022-02-12 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-13 04:21:00 | Logan, North Dakota, US | |
317269 | 317269 | 2022-02-12 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-13 04:21:00 | Stanton, Kansas, US | |
235651 | 235651 | 2022-02-11 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-12 04:21:06 | Logan, North Dakota, US | |
234595 | 234595 | 2022-02-11 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-12 04:21:06 | Stanton, Kansas, US | |
1466493 | 1466493 | 2022-02-10 | US | North Dakota | Logan | 38047 | 424 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-02-11 04:21:09 | Logan, North Dakota, US | |
1465437 | 1465437 | 2022-02-10 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-11 04:21:09 | Stanton, Kansas, US | |
3075398 | 3075398 | 2022-02-09 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-10 04:21:14 | Stanton, Kansas, US | |
1363705 | 1363705 | 2022-02-08 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-09 04:21:04 | Stanton, Kansas, US | |
72443 | 72443 | 2022-02-07 | US | Kansas | Stanton | 20187 | 424 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2022-02-08 04:21:15 | Stanton, Kansas, US | |
2015098 | 2015098 | 2022-02-06 | US | North Dakota | Burke | 38013 | 424 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2022-02-07 04:21:05 | Burke, North Dakota, US | |
1296427 | 1296427 | 2022-02-05 | US | North Dakota | Burke | 38013 | 424 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2022-02-06 04:21:00 | Burke, North Dakota, US | |
2329755 | 2329755 | 2022-02-04 | US | North Dakota | Burke | 38013 | 424 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2022-02-05 04:21:05 | Burke, North Dakota, US | |
2476346 | 2476346 | 2022-02-03 | US | North Dakota | Burke | 38013 | 424 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2022-02-04 04:21:10 | Burke, North Dakota, US | |
1143786 | 1143786 | 2022-01-23 | US | South Dakota | Haakon | 46055 | 424 | 11 | 0 | 44.29299053 | -101.539099 | 2022-01-24 04:21:12 | Haakon, South Dakota, US | |
1143314 | 1143314 | 2022-01-23 | US | North Dakota | Golden Valley | 38033 | 424 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-01-24 04:21:12 | Golden Valley, North Dakota, 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]);