johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
327 rows where confirmed = 1906 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753499 | 2753499 | 2022-12-29 | US | California | Trinity | 6105 | 1906 | 23 | 0 | 40.6491767 | -123.114713 | 2022-12-30 04:21:04 | Trinity, California, US | |
1074505 | 1074505 | 2022-12-28 | US | California | Trinity | 6105 | 1906 | 23 | 0 | 40.6491767 | -123.114713 | 2022-12-29 04:21:01 | Trinity, California, US | |
328502 | 328502 | 2022-12-27 | US | California | Trinity | 6105 | 1906 | 23 | 0 | 40.6491767 | -123.114713 | 2022-12-28 04:21:04 | Trinity, California, US | |
2416742 | 2416742 | 2022-12-05 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-06 04:21:03 | Wilkinson, Mississippi, US | |
720350 | 720350 | 2022-12-04 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-05 04:20:58 | Wilkinson, Mississippi, US | |
2818639 | 2818639 | 2022-12-03 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-04 04:20:56 | Wilkinson, Mississippi, US | |
835495 | 835495 | 2022-12-02 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-03 04:21:02 | Wilkinson, Mississippi, US | |
2138025 | 2138025 | 2022-12-01 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-02 04:21:07 | Wilkinson, Mississippi, US | |
1966441 | 1966441 | 2022-11-30 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-01 04:21:03 | Wilkinson, Mississippi, US | |
2558455 | 2558455 | 2022-11-29 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-11-30 04:21:07 | Wilkinson, Mississippi, US | |
1241529 | 1241529 | 2022-11-28 | US | Mississippi | Wilkinson | 28157 | 1906 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-11-29 04:21:05 | Wilkinson, Mississippi, US | |
713334 | 713334 | 2022-11-01 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-11-02 04:22:09 | Hutchinson, South Dakota, US | |
3287783 | 3287783 | 2022-10-31 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-11-01 04:22:36 | Hutchinson, South Dakota, US | |
322816 | 322816 | 2022-10-30 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-10-31 04:21:36 | Hutchinson, South Dakota, US | |
915092 | 915092 | 2022-10-29 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-10-30 04:22:14 | Hutchinson, South Dakota, US | |
1369361 | 1369361 | 2022-10-28 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-10-29 04:21:13 | Hutchinson, South Dakota, US | |
3041216 | 3041216 | 2022-10-27 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-10-28 04:22:31 | Hutchinson, South Dakota, US | |
541636 | 541636 | 2022-10-26 | US | South Dakota | Hutchinson | 46067 | 1906 | 39 | 0 | 43.33449012 | -97.75536441 | 2022-10-27 04:22:01 | Hutchinson, South Dakota, US | |
2531273 | 2531273 | 2022-10-06 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-07 04:23:08 | Chariton, Missouri, US | |
1812667 | 1812667 | 2022-10-05 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-06 04:21:22 | Chariton, Missouri, US | |
132641 | 132641 | 2022-10-04 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-05 04:23:06 | Chariton, Missouri, US | |
2687588 | 2687588 | 2022-10-03 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-04 04:22:55 | Chariton, Missouri, US | |
2261655 | 2261655 | 2022-10-02 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-03 04:23:11 | Chariton, Missouri, US | |
2997181 | 2997181 | 2022-10-01 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-02 04:21:23 | Chariton, Missouri, US | |
855507 | 855507 | 2022-09-30 | US | Missouri | Chariton | 29041 | 1906 | 40 | 0 | 39.51499357 | -92.9629191 | 2022-10-01 04:23:01 | Chariton, Missouri, US | |
3549387 | 3549387 | 2022-09-01 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-02 04:21:07 | Caldwell, Missouri, US | |
2345307 | 2345307 | 2022-08-31 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-01 04:21:03 | Caldwell, Missouri, US | |
3775787 | 3775787 | 2022-08-30 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-08-31 04:20:57 | Caldwell, Missouri, US | |
1682383 | 1682383 | 2022-08-29 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-08-30 04:21:03 | Caldwell, Missouri, US | |
1878867 | 1878867 | 2022-08-28 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-08-29 04:21:06 | Caldwell, Missouri, US | |
2097994 | 2097994 | 2022-08-27 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-08-28 04:21:02 | Caldwell, Missouri, US | |
1533809 | 1533809 | 2022-08-26 | US | Missouri | Caldwell | 29025 | 1906 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-08-27 04:20:57 | Caldwell, Missouri, US | |
2853042 | 2853042 | 2022-08-22 | Peru | Unknown | 1906 | 37 | 0 | 2022-08-23 04:20:56 | Unknown, Peru | |||||
1161651 | 1161651 | 2022-08-18 | US | Arkansas | Dallas | 5039 | 1906 | 34 | 0 | 33.97042763 | -92.65167437 | 2022-08-19 04:20:54 | Dallas, Arkansas, US | |
1087281 | 1087281 | 2022-08-09 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-10 04:20:57 | Ida, Iowa, US | |
3544696 | 3544696 | 2022-08-08 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-09 04:20:34 | Ida, Iowa, US | |
1071099 | 1071099 | 2022-08-07 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-08 04:21:08 | Ida, Iowa, US | |
1941687 | 1941687 | 2022-08-06 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-07 04:20:54 | Ida, Iowa, US | |
881486 | 881486 | 2022-08-05 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-06 04:20:56 | Ida, Iowa, US | |
2009897 | 2009897 | 2022-08-04 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-05 04:20:52 | Ida, Iowa, US | |
1099324 | 1099324 | 2022-08-03 | US | Iowa | Ida | 19093 | 1906 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-04 04:20:58 | Ida, Iowa, US | |
3210935 | 3210935 | 2022-07-18 | US | Colorado | Rio Blanco | 8103 | 1906 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-07-19 04:20:58 | Rio Blanco, Colorado, US | |
2493244 | 2493244 | 2022-06-29 | US | Texas | Stephens | 48429 | 1906 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-06-30 04:21:01 | Stephens, Texas, US | |
2242626 | 2242626 | 2022-06-28 | US | Texas | Stephens | 48429 | 1906 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-06-29 04:20:59 | Stephens, Texas, US | |
2150868 | 2150868 | 2022-06-27 | US | Texas | Stephens | 48429 | 1906 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-06-28 04:20:58 | Stephens, Texas, US | |
478669 | 478669 | 2022-06-26 | US | Texas | Stephens | 48429 | 1906 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-06-27 04:21:00 | Stephens, Texas, US | |
1766393 | 1766393 | 2022-06-20 | US | Texas | Crosby | 48107 | 1906 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-06-21 04:20:56 | Crosby, Texas, US | |
3272579 | 3272579 | 2022-06-19 | US | Texas | Crosby | 48107 | 1906 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-06-20 04:21:01 | Crosby, Texas, US | |
3000130 | 3000130 | 2022-05-24 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-25 04:20:56 | Irwin, Georgia, US | |
3593851 | 3593851 | 2022-05-23 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-24 04:20:57 | Irwin, Georgia, US | |
1110399 | 1110399 | 2022-05-21 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-22 04:20:52 | Irwin, Georgia, US | |
1170023 | 1170023 | 2022-05-20 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-21 04:20:58 | Irwin, Georgia, US | |
3896786 | 3896786 | 2022-05-19 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-20 04:20:57 | Irwin, Georgia, US | |
1185570 | 1185570 | 2022-05-18 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-19 04:20:54 | Irwin, Georgia, US | |
3583467 | 3583467 | 2022-05-17 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-18 04:20:50 | Irwin, Georgia, US | |
1504424 | 1504424 | 2022-05-16 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-17 04:20:59 | Irwin, Georgia, US | |
1504264 | 1504264 | 2022-05-16 | US | Colorado | Yuma | 8125 | 1906 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-05-17 04:20:59 | Yuma, Colorado, US | |
2084783 | 2084783 | 2022-05-15 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-16 04:20:47 | Irwin, Georgia, US | |
2084623 | 2084623 | 2022-05-15 | US | Colorado | Yuma | 8125 | 1906 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-05-16 04:20:47 | Yuma, Colorado, US | |
3355493 | 3355493 | 2022-05-14 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-15 04:20:53 | Irwin, Georgia, US | |
659138 | 659138 | 2022-05-13 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-14 04:20:48 | Irwin, Georgia, US | |
2534221 | 2534221 | 2022-05-12 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-13 04:20:51 | Irwin, Georgia, US | |
3445667 | 3445667 | 2022-05-11 | US | Georgia | Irwin | 13155 | 1906 | 51 | 0 | 31.60213036 | -83.27501387 | 2022-05-12 04:20:54 | Irwin, Georgia, US | |
3867355 | 3867355 | 2022-04-05 | China | Sichuan | 1906 | 3 | 0 | 30.6171 | 102.7103 | 2022-04-06 04:20:49 | Sichuan, China | |||
946063 | 946063 | 2022-02-28 | US | Texas | Swisher | 48437 | 1906 | 33 | 0 | 34.53028891 | -101.73491740000001 | 2022-03-01 04:21:09 | Swisher, Texas, US | |
2736254 | 2736254 | 2022-02-27 | US | Texas | Swisher | 48437 | 1906 | 33 | 0 | 34.53028891 | -101.73491740000001 | 2022-02-28 04:21:05 | Swisher, Texas, US | |
1514925 | 1514925 | 2022-02-24 | US | West Virginia | Tucker | 54093 | 1906 | 33 | 0 | 39.11240885 | -79.57053576 | 2022-02-25 04:21:11 | Tucker, West Virginia, US | |
3718695 | 3718695 | 2022-02-21 | US | Arkansas | Monroe | 5095 | 1906 | 31 | 0 | 34.6815935 | -91.20540287 | 2022-02-22 04:21:01 | Monroe, Arkansas, US | |
3673710 | 3673710 | 2022-02-15 | US | Nebraska | Cheyenne | 31033 | 1906 | 16 | 0 | 41.21999357 | -102.9941693 | 2022-02-16 04:21:10 | Cheyenne, Nebraska, US | |
2328284 | 2328284 | 2022-02-04 | US | Idaho | Benewah | 16009 | 1906 | 34 | 0 | 47.21754179 | -116.6586851 | 2022-02-05 04:21:05 | Benewah, Idaho, US | |
461173 | 461173 | 2022-02-02 | US | Mississippi | Choctaw | 28019 | 1906 | 28 | 0 | 33.34598242 | -89.24809382 | 2022-02-03 04:21:21 | Choctaw, Mississippi, US | |
982056 | 982056 | 2022-02-01 | US | Texas | Hamilton | 48193 | 1906 | 29 | 0 | 31.70470573 | -98.11083887 | 2022-02-02 04:21:09 | Hamilton, Texas, US | |
980891 | 980891 | 2022-02-01 | US | Missouri | Oregon | 29149 | 1906 | 28 | 0 | 36.68710164 | -91.4033755 | 2022-02-02 04:21:09 | Oregon, Missouri, US | |
2660699 | 2660699 | 2022-01-31 | US | South Dakota | Turner | 46125 | 1906 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-02-01 04:21:11 | Turner, South Dakota, US | |
3065477 | 3065477 | 2022-01-29 | US | West Virginia | Doddridge | 54017 | 1906 | 16 | 0 | 39.27057157 | -80.70671527 | 2022-01-30 04:21:26 | Doddridge, West Virginia, US | |
1780763 | 1780763 | 2022-01-27 | US | Kentucky | Bracken | 21023 | 1906 | 22 | 0 | 38.69158994 | -84.08532444 | 2022-01-28 04:21:09 | Bracken, Kentucky, US | |
1320300 | 1320300 | 2022-01-26 | US | Nebraska | Holt | 31089 | 1906 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-01-27 04:21:19 | Holt, Nebraska, US | |
2833281 | 2833281 | 2022-01-22 | US | Arizona | Greenlee | 4011 | 1906 | 30 | 0 | 33.21498827 | -109.2405279 | 2022-01-23 04:21:13 | Greenlee, Arizona, US | |
3688005 | 3688005 | 2022-01-13 | US | Arkansas | Scott | 5127 | 1906 | 35 | 0 | 34.85588887 | -94.0632176 | 2022-01-14 04:21:54 | Scott, Arkansas, US | |
1114985 | 1114985 | 2022-01-11 | US | Kentucky | Edmonson | 21061 | 1906 | 35 | 0 | 37.21218923 | -86.23955613 | 2022-01-12 04:21:44 | Edmonson, Kentucky, US | |
128495 | 128495 | 2022-01-09 | US | Minnesota | Rock | 27133 | 1906 | 32 | 0 | 43.67482683 | -96.25296832 | 2022-01-10 04:22:07 | Rock, Minnesota, US | |
1217330 | 1217330 | 2022-01-08 | US | Minnesota | Rock | 27133 | 1906 | 32 | 0 | 43.67482683 | -96.25296832 | 2022-01-09 04:21:46 | Rock, Minnesota, US | |
1391423 | 1391423 | 2022-01-07 | US | Minnesota | Rock | 27133 | 1906 | 32 | 0 | 43.67482683 | -96.25296832 | 2022-01-08 04:21:53 | Rock, Minnesota, US | |
1285390 | 1285390 | 2022-01-05 | US | Virginia | Richmond | 51159 | 1906 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-06 04:22:09 | Richmond, Virginia, US | |
1287861 | 1287861 | 2022-01-04 | US | Mississippi | Tunica | 28143 | 1906 | 40 | 0 | 34.64967704 | -90.37481167 | 2022-01-05 04:21:59 | Tunica, Mississippi, US | |
1671768 | 1671768 | 2021-12-29 | US | Virginia | Brunswick | 51025 | 1906 | 36 | 0 | 36.76366949 | -77.8593436 | 2021-12-30 04:21:25 | Brunswick, Virginia, US | |
2113535 | 2113535 | 2021-12-26 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-27 04:21:58 | Noxubee, Mississippi, US | |
3606907 | 3606907 | 2021-12-25 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-26 04:21:50 | Noxubee, Mississippi, US | |
2965225 | 2965225 | 2021-12-24 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-25 04:21:37 | Noxubee, Mississippi, US | |
3818257 | 3818257 | 2021-12-23 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-24 04:21:34 | Noxubee, Mississippi, US | |
800265 | 800265 | 2021-12-22 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-23 04:21:21 | Noxubee, Mississippi, US | |
799076 | 799076 | 2021-12-22 | US | Colorado | Park | 8093 | 1906 | 16 | 0 | 39.120926000000004 | -105.7182065 | 2021-12-23 04:21:21 | Park, Colorado, US | |
3830305 | 3830305 | 2021-12-21 | US | Mississippi | Noxubee | 28103 | 1906 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-22 04:21:54 | Noxubee, Mississippi, US | |
783761 | 783761 | 2021-12-13 | US | Kentucky | Bath | 21011 | 1906 | 34 | 0 | 38.14735938 | -83.74588932 | 2021-12-14 04:22:38 | Bath, Kentucky, US | |
1080973 | 1080973 | 2021-12-09 | US | Texas | Childress | 48075 | 1906 | 22 | 0 | 34.529304100000004 | -100.2077916 | 2021-12-10 04:22:28 | Childress, Texas, US | |
552937 | 552937 | 2021-12-08 | US | New Hampshire | Unassigned | 90033 | 1906 | 12 | 0 | 44.69063265 | 0.0 | 2021-12-09 04:22:49 | Unassigned, New Hampshire, US | |
1742425 | 1742425 | 2021-12-05 | US | Missouri | Cedar | 29039 | 1906 | 42 | 0 | 37.72391475 | -93.85445441 | 2021-12-06 04:22:34 | Cedar, Missouri, US | |
151909 | 151909 | 2021-11-29 | US | Missouri | Linn | 29115 | 1906 | 27 | 0 | 39.87001769 | -93.10704106 | 2021-11-30 04:22:53 | Linn, Missouri, US | |
151009 | 151009 | 2021-11-29 | US | Illinois | Menard | 17129 | 1906 | 14 | 0 | 40.02742725 | -89.80246001 | 2021-11-30 04:22:53 | Menard, Illinois, US | |
150587 | 150587 | 2021-11-29 | US | Colorado | Bent | 8011 | 1906 | 38 | 0 | 37.95474293 | -103.0720195 | 2021-11-30 04:22:53 | Bent, Colorado, 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]);