johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
680 rows where confirmed = 460 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559474 | 2559474 | 2022-11-29 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-30 04:21:07 | Jerauld, South Dakota, US | |
1242548 | 1242548 | 2022-11-28 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-29 04:21:05 | Jerauld, South Dakota, US | |
3554536 | 3554536 | 2022-11-27 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-28 04:21:02 | Jerauld, South Dakota, US | |
2103016 | 2103016 | 2022-11-26 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-27 04:21:05 | Jerauld, South Dakota, US | |
490507 | 490507 | 2022-11-25 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-26 04:21:11 | Jerauld, South Dakota, US | |
3526336 | 3526336 | 2022-11-24 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-25 04:21:06 | Jerauld, South Dakota, US | |
3315119 | 3315119 | 2022-11-23 | US | South Dakota | Jerauld | 46073 | 460 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-11-24 04:21:09 | Jerauld, South Dakota, US | |
1814136 | 1814136 | 2022-10-05 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-06 04:21:22 | Highland, Virginia, US | |
134110 | 134110 | 2022-10-04 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-05 04:23:06 | Highland, Virginia, US | |
133645 | 133645 | 2022-10-04 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-10-05 04:23:06 | McPherson, South Dakota, US | |
2689057 | 2689057 | 2022-10-03 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-04 04:22:55 | Highland, Virginia, US | |
2688592 | 2688592 | 2022-10-03 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-10-04 04:22:55 | McPherson, South Dakota, US | |
2263124 | 2263124 | 2022-10-02 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-03 04:23:11 | Highland, Virginia, US | |
2262659 | 2262659 | 2022-10-02 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-10-03 04:23:11 | McPherson, South Dakota, US | |
2998650 | 2998650 | 2022-10-01 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-02 04:21:23 | Highland, Virginia, US | |
2998185 | 2998185 | 2022-10-01 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-10-02 04:21:23 | McPherson, South Dakota, US | |
856976 | 856976 | 2022-09-30 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-01 04:23:01 | Highland, Virginia, US | |
856511 | 856511 | 2022-09-30 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-10-01 04:23:01 | McPherson, South Dakota, US | |
2378902 | 2378902 | 2022-09-29 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-09-30 04:23:09 | Highland, Virginia, US | |
2378437 | 2378437 | 2022-09-29 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-30 04:23:09 | McPherson, South Dakota, US | |
1563453 | 1563453 | 2022-09-28 | US | Virginia | Highland | 51091 | 460 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-09-29 04:22:34 | Highland, Virginia, US | |
1562988 | 1562988 | 2022-09-28 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-29 04:22:34 | McPherson, South Dakota, US | |
3997531 | 3997531 | 2022-09-27 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-28 04:23:01 | McPherson, South Dakota, US | |
2771859 | 2771859 | 2022-09-26 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-27 04:23:01 | McPherson, South Dakota, US | |
1979512 | 1979512 | 2022-09-25 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-26 04:20:52 | McPherson, South Dakota, US | |
2652679 | 2652679 | 2022-09-24 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-25 04:23:31 | McPherson, South Dakota, US | |
387119 | 387119 | 2022-09-23 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-24 04:21:40 | McPherson, South Dakota, US | |
1627185 | 1627185 | 2022-09-22 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-23 04:23:13 | McPherson, South Dakota, US | |
1373389 | 1373389 | 2022-09-21 | US | South Dakota | McPherson | 46089 | 460 | 10 | 0 | 45.76626028 | -99.22118798 | 2022-09-22 04:22:56 | McPherson, South Dakota, US | |
2635796 | 2635796 | 2022-09-05 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-06 04:21:02 | Franklin, Nebraska, US | |
2989360 | 2989360 | 2022-09-04 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-05 04:21:01 | Franklin, Nebraska, US | |
2715045 | 2715045 | 2022-09-03 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-04 04:21:22 | Franklin, Nebraska, US | |
1395750 | 1395750 | 2022-09-02 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-03 04:21:04 | Franklin, Nebraska, US | |
3549579 | 3549579 | 2022-09-01 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-02 04:21:07 | Franklin, Nebraska, US | |
2345499 | 2345499 | 2022-08-31 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-09-01 04:21:03 | Franklin, Nebraska, US | |
3775979 | 3775979 | 2022-08-30 | US | Nebraska | Franklin | 31061 | 460 | 12 | 0 | 40.17636348 | -98.95299073 | 2022-08-31 04:20:57 | Franklin, Nebraska, US | |
2743027 | 2743027 | 2022-07-07 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-08 04:20:56 | Meagher, Montana, US | |
1201822 | 1201822 | 2022-07-06 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-07 04:20:55 | Meagher, Montana, US | |
3968565 | 3968565 | 2022-07-05 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-06 04:20:58 | Meagher, Montana, US | |
3080076 | 3080076 | 2022-07-04 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-05 04:20:45 | Meagher, Montana, US | |
1769358 | 1769358 | 2022-07-03 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-04 04:20:54 | Meagher, Montana, US | |
3367344 | 3367344 | 2022-07-02 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-03 04:20:59 | Meagher, Montana, US | |
595673 | 595673 | 2022-07-01 | US | Montana | Meagher | 30059 | 460 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-07-02 04:21:16 | Meagher, Montana, US | |
2150046 | 2150046 | 2022-06-27 | US | North Dakota | Grant | 38037 | 460 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-06-28 04:20:58 | Grant, North Dakota, US | |
168919 | 168919 | 2022-06-21 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-22 04:20:54 | Haakon, South Dakota, US | |
1766202 | 1766202 | 2022-06-20 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-21 04:20:56 | Haakon, South Dakota, US | |
3272388 | 3272388 | 2022-06-19 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-20 04:21:01 | Haakon, South Dakota, US | |
3400300 | 3400300 | 2022-06-18 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-19 04:20:51 | Haakon, South Dakota, US | |
2314177 | 2314177 | 2022-06-17 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-18 04:21:10 | Haakon, South Dakota, US | |
561681 | 561681 | 2022-06-16 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-17 04:20:56 | Haakon, South Dakota, US | |
3985483 | 3985483 | 2022-06-15 | US | South Dakota | Haakon | 46055 | 460 | 12 | 0 | 44.29299053 | -101.539099 | 2022-06-16 04:20:55 | Haakon, South Dakota, US | |
3267894 | 3267894 | 2022-05-04 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-05 04:20:55 | Divide, North Dakota, US | |
1574533 | 1574533 | 2022-05-03 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-04 04:20:59 | Divide, North Dakota, US | |
465793 | 465793 | 2022-05-02 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-03 04:21:00 | Divide, North Dakota, US | |
3918432 | 3918432 | 2022-05-01 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-02 04:21:10 | Divide, North Dakota, US | |
2843236 | 2843236 | 2022-04-30 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-01 04:20:57 | Divide, North Dakota, US | |
1159549 | 1159549 | 2022-04-29 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-04-30 04:21:05 | Divide, North Dakota, US | |
1698731 | 1698731 | 2022-04-28 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-04-29 04:20:59 | Divide, North Dakota, US | |
3854214 | 3854214 | 2022-04-27 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-04-28 04:20:47 | Divide, North Dakota, US | |
1328644 | 1328644 | 2022-04-26 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-27 04:20:52 | Divide, North Dakota, US | |
3724598 | 3724598 | 2022-04-25 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-26 04:20:51 | Divide, North Dakota, US | |
2031166 | 2031166 | 2022-04-24 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-25 04:20:56 | Divide, North Dakota, US | |
748741 | 748741 | 2022-04-23 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-24 04:20:56 | Divide, North Dakota, US | |
3439226 | 3439226 | 2022-04-22 | US | North Dakota | Divide | 38023 | 460 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-23 04:20:50 | Divide, North Dakota, US | |
694831 | 694831 | 2022-03-17 | US | Alaska | Wrangell | 2275 | 460 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-03-18 04:20:55 | Wrangell, Alaska, US | |
2319774 | 2319774 | 2022-03-16 | US | Alaska | Wrangell | 2275 | 460 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-03-17 04:20:56 | Wrangell, Alaska, US | |
1364630 | 1364630 | 2022-02-08 | US | New York | Unassigned | 90036 | 460 | 1 | 0 | 44.74530905 | 0.0 | 2022-02-09 04:21:04 | Unassigned, New York, US | |
1362795 | 1362795 | 2022-02-08 | US | Alaska | Yakutat | 2282 | 460 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-02-09 04:21:04 | Yakutat, Alaska, US | |
71533 | 71533 | 2022-02-07 | US | Alaska | Yakutat | 2282 | 460 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-02-08 04:21:15 | Yakutat, Alaska, US | |
2657827 | 2657827 | 2022-01-31 | Kiribati | 460 | 0 | 0 | -3.3704 | -168.734 | 2022-02-01 04:21:11 | Kiribati | ||||
1143929 | 1143929 | 2022-01-23 | US | Texas | Armstrong | 48011 | 460 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-01-24 04:21:12 | Armstrong, Texas, US | |
1961333 | 1961333 | 2022-01-20 | US | Georgia | Clay | 13061 | 460 | 4 | 0 | 31.62221166 | -84.97713865 | 2022-01-21 04:21:09 | Clay, Georgia, US | |
3466261 | 3466261 | 2022-01-18 | US | Nebraska | Hitchcock | 31087 | 460 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-01-19 04:21:23 | Hitchcock, Nebraska, US | |
1694390 | 1694390 | 2022-01-10 | US | Nebraska | Frontier | 31063 | 460 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-01-11 04:22:01 | Frontier, Nebraska, US | |
129608 | 129608 | 2022-01-09 | US | South Dakota | Hand | 46059 | 460 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-10 04:22:07 | Hand, South Dakota, US | |
1218712 | 1218712 | 2022-01-08 | US | Texas | Kimble | 48267 | 460 | 11 | 0 | 30.48678918 | -99.74856473 | 2022-01-09 04:21:46 | Kimble, Texas, US | |
1218443 | 1218443 | 2022-01-08 | US | South Dakota | Hand | 46059 | 460 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-09 04:21:46 | Hand, South Dakota, US | |
1392536 | 1392536 | 2022-01-07 | US | South Dakota | Hand | 46059 | 460 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-08 04:21:53 | Hand, South Dakota, US | |
2610461 | 2610461 | 2022-01-06 | US | Alaska | Aleutians East | 2013 | 460 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-07 04:22:09 | Aleutians East, Alaska, US | |
1282403 | 1282403 | 2022-01-05 | US | Alaska | Aleutians East | 2013 | 460 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-06 04:22:09 | Aleutians East, Alaska, US | |
3521555 | 3521555 | 2022-01-02 | US | Nebraska | Sherman | 31163 | 460 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-03 02:22:25 | Sherman, Nebraska, US | |
3520043 | 3520043 | 2022-01-02 | US | Colorado | Costilla | 8023 | 460 | 14 | 0 | 37.27732493 | -105.4276548 | 2022-01-03 02:22:25 | Costilla, Colorado, US | |
2169685 | 2169685 | 2022-01-01 | US | Nebraska | Sherman | 31163 | 460 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-02 04:20:52 | Sherman, Nebraska, US | |
2779116 | 2779116 | 2021-12-31 | US | Nebraska | Sherman | 31163 | 460 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-01 04:22:14 | Sherman, Nebraska, US | |
4000773 | 4000773 | 2021-12-30 | US | Nebraska | Sherman | 31163 | 460 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-12-31 04:21:50 | Sherman, Nebraska, US | |
2113904 | 2113904 | 2021-12-26 | US | New Mexico | Mora | 35033 | 460 | 14 | 0 | 36.01095101 | -104.9497716 | 2021-12-27 04:21:58 | Mora, New Mexico, US | |
3607276 | 3607276 | 2021-12-25 | US | New Mexico | Mora | 35033 | 460 | 14 | 0 | 36.01095101 | -104.9497716 | 2021-12-26 04:21:50 | Mora, New Mexico, US | |
2965594 | 2965594 | 2021-12-24 | US | New Mexico | Mora | 35033 | 460 | 14 | 0 | 36.01095101 | -104.9497716 | 2021-12-25 04:21:37 | Mora, New Mexico, US | |
3818626 | 3818626 | 2021-12-23 | US | New Mexico | Mora | 35033 | 460 | 14 | 0 | 36.01095101 | -104.9497716 | 2021-12-24 04:21:34 | Mora, New Mexico, US | |
2907173 | 2907173 | 2021-12-19 | US | Washington | San Juan | 53055 | 460 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-20 04:21:43 | San Juan, Washington, US | |
1262246 | 1262246 | 2021-12-18 | US | Washington | San Juan | 53055 | 460 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-19 04:21:11 | San Juan, Washington, US | |
2402274 | 2402274 | 2021-12-17 | US | Washington | San Juan | 53055 | 460 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-18 02:22:20 | San Juan, Washington, US | |
1719812 | 1719812 | 2021-12-16 | US | Washington | San Juan | 53055 | 460 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-17 04:22:14 | San Juan, Washington, US | |
2090359 | 2090359 | 2021-12-14 | US | North Dakota | Adams | 38001 | 460 | 8 | 0 | 46.09686891 | -102.5285397 | 2021-12-15 03:22:16 | Adams, North Dakota, US | |
784823 | 784823 | 2021-12-13 | US | North Dakota | Towner | 38095 | 460 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-14 04:22:38 | Towner, North Dakota, US | |
1661707 | 1661707 | 2021-12-12 | US | Kansas | Edwards | 20047 | 460 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-12-13 04:22:02 | Edwards, Kansas, US | |
1667203 | 1667203 | 2021-12-11 | US | Puerto Rico | Maunabo | 72095 | 460 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-12 04:22:12 | Maunabo, Puerto Rico, US | |
1665723 | 1665723 | 2021-12-11 | US | Kansas | Edwards | 20047 | 460 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-12-12 04:22:12 | Edwards, Kansas, US | |
3658355 | 3658355 | 2021-12-10 | US | Puerto Rico | Maunabo | 72095 | 460 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-11 04:22:45 | Maunabo, Puerto Rico, US | |
3656875 | 3656875 | 2021-12-10 | US | Kansas | Edwards | 20047 | 460 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-12-11 04:22:45 | Edwards, Kansas, 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]);