johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,238 rows where confirmed = 234 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 933
- Australia 238
- China 27
- Japan 18
- Tonga 4
- Antigua and Barbuda 2
- Barbados 2
- Bhutan 2
- Peru 2
- Cambodia 1
- Colombia 1
- Congo (Kinshasa) 1
- Georgia 1
- Haiti 1
- India 1
- Kenya 1
- Monaco 1
- Mozambique 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
718286 | 718286 | 2022-12-04 | China | Ningxia | 234 | 0 | 0 | 37.2692 | 106.1655 | 2022-12-05 04:20:58 | Ningxia, China | |||
2816575 | 2816575 | 2022-12-03 | China | Ningxia | 234 | 0 | 0 | 37.2692 | 106.1655 | 2022-12-04 04:20:56 | Ningxia, China | |||
375289 | 375289 | 2022-09-13 | US | Texas | Foard | 48155 | 234 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-09-14 04:20:44 | Foard, Texas, US | |
2397891 | 2397891 | 2022-09-12 | US | Texas | Foard | 48155 | 234 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-09-13 04:20:57 | Foard, Texas, US | |
3768969 | 3768969 | 2022-09-11 | US | Texas | Foard | 48155 | 234 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-09-12 04:20:58 | Foard, Texas, US | |
3827544 | 3827544 | 2022-09-10 | US | Texas | Foard | 48155 | 234 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-09-11 04:20:50 | Foard, Texas, US | |
966001 | 966001 | 2022-09-09 | US | Texas | Foard | 48155 | 234 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-09-10 04:21:10 | Foard, Texas, US | |
2743020 | 2743020 | 2022-07-07 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-08 04:20:56 | Judith Basin, Montana, US | |
1201815 | 1201815 | 2022-07-06 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-07 04:20:55 | Judith Basin, Montana, US | |
3968558 | 3968558 | 2022-07-05 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-06 04:20:58 | Judith Basin, Montana, US | |
3080069 | 3080069 | 2022-07-04 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-05 04:20:45 | Judith Basin, Montana, US | |
1769351 | 1769351 | 2022-07-03 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-04 04:20:54 | Judith Basin, Montana, US | |
3367337 | 3367337 | 2022-07-02 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-03 04:20:59 | Judith Basin, Montana, US | |
595666 | 595666 | 2022-07-01 | US | Montana | Judith Basin | 30045 | 234 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-07-02 04:21:16 | Judith Basin, Montana, US | |
3720175 | 3720175 | 2022-02-21 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-22 04:21:01 | Carter, Montana, US | |
3718526 | 3718526 | 2022-02-21 | Tonga | 234 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-22 04:21:01 | Tonga | ||||
3914009 | 3914009 | 2022-02-20 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-21 04:21:05 | Carter, Montana, US | |
3912360 | 3912360 | 2022-02-20 | Tonga | 234 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-21 04:21:05 | Tonga | ||||
3877567 | 3877567 | 2022-02-19 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-20 04:21:00 | Carter, Montana, US | |
3875918 | 3875918 | 2022-02-19 | Tonga | 234 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-20 04:21:00 | Tonga | ||||
3857823 | 3857823 | 2022-02-18 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-19 04:21:11 | Carter, Montana, US | |
3856174 | 3856174 | 2022-02-18 | Tonga | 234 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-19 04:21:11 | Tonga | ||||
1300042 | 1300042 | 2022-02-17 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-18 04:21:04 | Carter, Montana, US | |
3822428 | 3822428 | 2022-02-16 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-17 04:20:56 | Carter, Montana, US | |
3673642 | 3673642 | 2022-02-15 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-16 04:21:10 | Carter, Montana, US | |
2643743 | 2643743 | 2022-02-14 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-15 04:21:09 | Carter, Montana, US | |
188060 | 188060 | 2022-02-13 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-14 04:20:51 | Carter, Montana, US | |
317906 | 317906 | 2022-02-12 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-13 04:21:00 | Carter, Montana, US | |
235232 | 235232 | 2022-02-11 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-12 04:21:06 | Carter, Montana, US | |
1466074 | 1466074 | 2022-02-10 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-11 04:21:09 | Carter, Montana, US | |
3076035 | 3076035 | 2022-02-09 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-10 04:21:14 | Carter, Montana, US | |
1364342 | 1364342 | 2022-02-08 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-09 04:21:04 | Carter, Montana, US | |
73080 | 73080 | 2022-02-07 | US | Montana | Carter | 30011 | 234 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-02-08 04:21:15 | Carter, Montana, US | |
71729 | 71729 | 2022-02-07 | US | Colorado | Mineral | 8079 | 234 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-02-08 04:21:15 | Mineral, Colorado, US | |
2013345 | 2013345 | 2022-02-06 | US | Colorado | Mineral | 8079 | 234 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-02-07 04:21:05 | Mineral, Colorado, US | |
1294674 | 1294674 | 2022-02-05 | US | Colorado | Mineral | 8079 | 234 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-02-06 04:21:00 | Mineral, Colorado, US | |
2328002 | 2328002 | 2022-02-04 | US | Colorado | Mineral | 8079 | 234 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-02-05 04:21:05 | Mineral, Colorado, US | |
2474593 | 2474593 | 2022-02-03 | US | Colorado | Mineral | 8079 | 234 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-02-04 04:21:10 | Mineral, Colorado, US | |
1782292 | 1782292 | 2022-01-27 | US | South Dakota | Sully | 46119 | 234 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-28 04:21:09 | Sully, South Dakota, US | |
1321120 | 1321120 | 2022-01-26 | US | South Dakota | Sully | 46119 | 234 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-27 04:21:19 | Sully, South Dakota, US | |
1320238 | 1320238 | 2022-01-26 | US | Montana | Prairie | 30079 | 234 | 3 | 0 | 46.86048047 | -105.379384 | 2022-01-27 04:21:19 | Prairie, Montana, US | |
1319093 | 1319093 | 2022-01-26 | US | Georgia | Taliaferro | 13265 | 234 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-27 04:21:19 | Taliaferro, Georgia, US | |
2053906 | 2053906 | 2022-01-25 | US | Montana | Prairie | 30079 | 234 | 3 | 0 | 46.86048047 | -105.379384 | 2022-01-26 04:21:07 | Prairie, Montana, US | |
1963783 | 1963783 | 2022-01-20 | US | Texas | Sterling | 48431 | 234 | 5 | 0 | 31.82781912 | -101.05007459999999 | 2022-01-21 04:21:09 | Sterling, Texas, US | |
1285118 | 1285118 | 2022-01-05 | US | Texas | Irion | 48235 | 234 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-06 04:22:09 | Irion, Texas, US | |
1703230 | 1703230 | 2022-01-03 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-04 04:22:17 | Hyde, South Dakota, US | |
1702499 | 1702499 | 2022-01-03 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2022-01-04 04:22:17 | Storey, Nevada, US | |
1700934 | 1700934 | 2022-01-03 | US | California | Sierra | 6091 | 234 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-04 04:22:17 | Sierra, California, US | |
3522789 | 3522789 | 2022-01-02 | US | Virginia | Highland | 51091 | 234 | 4 | 0 | 38.35799465 | -79.56124594 | 2022-01-03 02:22:25 | Highland, Virginia, US | |
3522313 | 3522313 | 2022-01-02 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-03 02:22:25 | Hyde, South Dakota, US | |
3521582 | 3521582 | 2022-01-02 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2022-01-03 02:22:25 | Storey, Nevada, US | |
2170919 | 2170919 | 2022-01-01 | US | Virginia | Highland | 51091 | 234 | 4 | 0 | 38.35799465 | -79.56124594 | 2022-01-02 04:20:52 | Highland, Virginia, US | |
2170443 | 2170443 | 2022-01-01 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-02 04:20:52 | Hyde, South Dakota, US | |
2169712 | 2169712 | 2022-01-01 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2022-01-02 04:20:52 | Storey, Nevada, US | |
2780350 | 2780350 | 2021-12-31 | US | Virginia | Highland | 51091 | 234 | 4 | 0 | 38.35799465 | -79.56124594 | 2022-01-01 04:22:14 | Highland, Virginia, US | |
2779874 | 2779874 | 2021-12-31 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-01 04:22:14 | Hyde, South Dakota, US | |
2779143 | 2779143 | 2021-12-31 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2022-01-01 04:22:14 | Storey, Nevada, US | |
4001531 | 4001531 | 2021-12-30 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-31 04:21:50 | Hyde, South Dakota, US | |
4001077 | 4001077 | 2021-12-30 | US | North Dakota | Sheridan | 38083 | 234 | 6 | 0 | 47.57700669 | -100.3426391 | 2021-12-31 04:21:50 | Sheridan, North Dakota, US | |
4000928 | 4000928 | 2021-12-30 | US | New York | Unassigned | 90036 | 234 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-31 04:21:50 | Unassigned, New York, US | |
4000800 | 4000800 | 2021-12-30 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-31 04:21:50 | Storey, Nevada, US | |
1671338 | 1671338 | 2021-12-29 | US | South Dakota | Hyde | 46069 | 234 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-30 04:21:25 | Hyde, South Dakota, US | |
1670884 | 1670884 | 2021-12-29 | US | North Dakota | Sheridan | 38083 | 234 | 6 | 0 | 47.57700669 | -100.3426391 | 2021-12-30 04:21:25 | Sheridan, North Dakota, US | |
1670607 | 1670607 | 2021-12-29 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-30 04:21:25 | Storey, Nevada, US | |
1434716 | 1434716 | 2021-12-28 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-29 03:21:43 | Storey, Nevada, US | |
732677 | 732677 | 2021-12-27 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-28 04:21:47 | Storey, Nevada, US | |
2113849 | 2113849 | 2021-12-26 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-27 04:21:58 | Storey, Nevada, US | |
3607221 | 3607221 | 2021-12-25 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-26 04:21:50 | Storey, Nevada, US | |
2965539 | 2965539 | 2021-12-24 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-25 04:21:37 | Storey, Nevada, US | |
3818571 | 3818571 | 2021-12-23 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-24 04:21:34 | Storey, Nevada, US | |
800579 | 800579 | 2021-12-22 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-23 04:21:21 | Storey, Nevada, US | |
3830619 | 3830619 | 2021-12-21 | US | Nevada | Storey | 32029 | 234 | 8 | 0 | 39.44875482 | -119.5250207 | 2021-12-22 04:21:54 | Storey, Nevada, US | |
1663717 | 1663717 | 2021-12-12 | US | Vermont | Unassigned | 90050 | 234 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-13 04:22:02 | Unassigned, Vermont, US | |
3072446 | 3072446 | 2021-11-23 | US | North Dakota | Oliver | 38065 | 234 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-11-24 04:22:14 | Oliver, North Dakota, US | |
449353 | 449353 | 2021-11-17 | US | Missouri | Worth | 29227 | 234 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-18 04:21:33 | Worth, Missouri, US | |
3345682 | 3345682 | 2021-11-16 | US | Texas | Cottle | 48101 | 234 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-11-17 04:21:48 | Cottle, Texas, US | |
5644 | 5644 | 2021-10-28 | US | Kansas | Hodgeman | 20083 | 234 | 10 | 0 | 38.08780079 | -99.89829881 | 2021-10-29 04:22:03 | Hodgeman, Kansas, US | |
536034 | 536034 | 2021-10-27 | US | Kansas | Hodgeman | 20083 | 234 | 10 | 0 | 38.08780079 | -99.89829881 | 2021-10-28 04:22:08 | Hodgeman, Kansas, US | |
3493471 | 3493471 | 2021-10-26 | US | Kansas | Hodgeman | 20083 | 234 | 10 | 0 | 38.08780079 | -99.89829881 | 2021-10-27 04:22:32 | Hodgeman, Kansas, US | |
3795193 | 3795193 | 2021-10-25 | US | Kansas | Hodgeman | 20083 | 234 | 10 | 0 | 38.08780079 | -99.89829881 | 2021-10-26 04:22:09 | Hodgeman, Kansas, US | |
599032 | 599032 | 2021-10-19 | US | Kansas | Wallace | 20199 | 234 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-20 04:21:00 | Wallace, Kansas, US | |
2045919 | 2045919 | 2021-10-18 | US | Nebraska | Dundy | 31057 | 234 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-10-19 04:20:54 | Dundy, Nebraska, US | |
2045209 | 2045209 | 2021-10-18 | US | Kansas | Wallace | 20199 | 234 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-19 04:20:54 | Wallace, Kansas, US | |
1923324 | 1923324 | 2021-09-24 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-25 04:21:31 | Pawnee, Nebraska, US | |
603795 | 603795 | 2021-09-23 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-24 04:21:44 | Pawnee, Nebraska, US | |
3013439 | 3013439 | 2021-09-22 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-23 04:21:43 | Pawnee, Nebraska, US | |
3760935 | 3760935 | 2021-09-21 | US | Washington | Wahkiakum | 53069 | 234 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-09-22 04:21:45 | Wahkiakum, Washington, US | |
3759577 | 3759577 | 2021-09-21 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-22 04:21:45 | Pawnee, Nebraska, US | |
811680 | 811680 | 2021-09-20 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-21 04:21:26 | Pawnee, Nebraska, US | |
1816879 | 1816879 | 2021-09-19 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-20 04:21:22 | Pawnee, Nebraska, US | |
18459 | 18459 | 2021-09-18 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-19 04:21:34 | Pawnee, Nebraska, US | |
2620144 | 2620144 | 2021-09-17 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-18 04:21:24 | Pawnee, Nebraska, US | |
2810852 | 2810852 | 2021-09-16 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-17 04:21:46 | Pawnee, Nebraska, US | |
1376596 | 1376596 | 2021-09-15 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-16 04:22:19 | Pawnee, Nebraska, US | |
2464895 | 2464895 | 2021-09-14 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-15 03:22:37 | Pawnee, Nebraska, US | |
1387734 | 1387734 | 2021-09-13 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-14 04:21:41 | Pawnee, Nebraska, US | |
1386492 | 1386492 | 2021-09-13 | US | Georgia | Quitman | 13239 | 234 | 3 | 0 | 31.86728114 | -85.01773177 | 2021-09-14 04:21:41 | Quitman, Georgia, US | |
1887103 | 1887103 | 2021-09-12 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-13 04:21:15 | Pawnee, Nebraska, US | |
3808006 | 3808006 | 2021-09-11 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-12 04:21:13 | Pawnee, Nebraska, US | |
3450946 | 3450946 | 2021-09-10 | US | Nebraska | Pawnee | 31133 | 234 | 1 | 0 | 40.13141096 | -96.23705437 | 2021-09-11 04:21:30 | Pawnee, Nebraska, 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]);