johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
312 rows where confirmed = 1998 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621502 | 1621502 | 2022-11-22 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-23 04:21:06 | Monona, Iowa, US | |
3461390 | 3461390 | 2022-11-21 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-22 04:20:47 | Monona, Iowa, US | |
1641575 | 1641575 | 2022-11-20 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-21 04:21:05 | Monona, Iowa, US | |
2065132 | 2065132 | 2022-11-19 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-20 04:21:08 | Monona, Iowa, US | |
1756526 | 1756526 | 2022-11-18 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-19 04:21:14 | Monona, Iowa, US | |
3027519 | 3027519 | 2022-11-17 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-18 04:21:15 | Monona, Iowa, US | |
2487230 | 2487230 | 2022-11-16 | US | Iowa | Monona | 19133 | 1998 | 51 | 0 | 42.05220391 | -95.95743843 | 2022-11-17 04:21:11 | Monona, Iowa, US | |
115404 | 115404 | 2022-09-06 | US | Colorado | Rio Blanco | 8103 | 1998 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-09-07 04:20:59 | Rio Blanco, Colorado, US | |
2634376 | 2634376 | 2022-09-05 | US | Colorado | Rio Blanco | 8103 | 1998 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-09-06 04:21:02 | Rio Blanco, Colorado, US | |
2987940 | 2987940 | 2022-09-04 | US | Colorado | Rio Blanco | 8103 | 1998 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-09-05 04:21:01 | Rio Blanco, Colorado, US | |
2713625 | 2713625 | 2022-09-03 | US | Colorado | Rio Blanco | 8103 | 1998 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-09-04 04:21:22 | Rio Blanco, Colorado, US | |
1394330 | 1394330 | 2022-09-02 | US | Colorado | Rio Blanco | 8103 | 1998 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-09-03 04:21:04 | Rio Blanco, Colorado, US | |
2326333 | 2326333 | 2022-08-24 | US | Tennessee | Pickett | 47137 | 1998 | 38 | 0 | 36.55606529 | -85.077633 | 2022-08-25 04:21:13 | Pickett, Tennessee, US | |
1254018 | 1254018 | 2022-08-23 | US | Texas | Winkler | 48495 | 1998 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-24 04:20:46 | Winkler, Texas, US | |
1089080 | 1089080 | 2022-08-09 | US | Tennessee | Van Buren | 47175 | 1998 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-10 04:20:57 | Van Buren, Tennessee, US | |
3546698 | 3546698 | 2022-08-08 | US | Texas | Refugio | 48391 | 1998 | 38 | 0 | 28.3238976 | -97.15766311 | 2022-08-09 04:20:34 | Refugio, Texas, US | |
1100739 | 1100739 | 2022-08-03 | US | Oregon | Grant | 41023 | 1998 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-08-04 04:20:58 | Grant, Oregon, US | |
3620508 | 3620508 | 2022-08-01 | US | Virginia | Williamsburg | 51830 | 1998 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-08-02 04:20:53 | Williamsburg, Virginia, US | |
2597141 | 2597141 | 2022-07-25 | US | Texas | Hamilton | 48193 | 1998 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-07-26 04:20:58 | Hamilton, Texas, US | |
899256 | 899256 | 2022-07-24 | US | Texas | Hamilton | 48193 | 1998 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-07-25 04:20:51 | Hamilton, Texas, US | |
94250 | 94250 | 2022-07-23 | US | Texas | Hamilton | 48193 | 1998 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-07-24 04:20:47 | Hamilton, Texas, US | |
1420197 | 1420197 | 2022-07-08 | US | Texas | Hansford | 48195 | 1998 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-07-09 04:20:59 | Hansford, Texas, US | |
2744122 | 2744122 | 2022-07-07 | US | Texas | Hansford | 48195 | 1998 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-07-08 04:20:56 | Hansford, Texas, US | |
476076 | 476076 | 2022-06-26 | US | Colorado | Lake | 8065 | 1998 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-27 04:21:00 | Lake, Colorado, US | |
1648900 | 1648900 | 2022-06-23 | US | Arkansas | Prairie | 5117 | 1998 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-24 04:20:58 | Prairie, Arkansas, US | |
2190002 | 2190002 | 2022-06-22 | US | North Dakota | Benson | 38005 | 1998 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-06-23 04:20:55 | Benson, North Dakota, US | |
2188135 | 2188135 | 2022-06-22 | US | Arkansas | Prairie | 5117 | 1998 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-23 04:20:55 | Prairie, Arkansas, US | |
168433 | 168433 | 2022-06-21 | US | North Dakota | Benson | 38005 | 1998 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-06-22 04:20:54 | Benson, North Dakota, US | |
559471 | 559471 | 2022-06-16 | US | Colorado | Yuma | 8125 | 1998 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-06-17 04:20:56 | Yuma, Colorado, US | |
3141379 | 3141379 | 2022-06-11 | China | Inner Mongolia | 1998 | 1 | 0 | 44.0935 | 113.9448 | 2022-06-12 04:20:53 | Inner Mongolia, China | |||
2086378 | 2086378 | 2022-05-15 | US | North Dakota | Pembina | 38067 | 1998 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-16 04:20:47 | Pembina, North Dakota, US | |
3357088 | 3357088 | 2022-05-14 | US | North Dakota | Pembina | 38067 | 1998 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-15 04:20:53 | Pembina, North Dakota, US | |
660733 | 660733 | 2022-05-13 | US | North Dakota | Pembina | 38067 | 1998 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-14 04:20:48 | Pembina, North Dakota, US | |
2536903 | 2536903 | 2022-05-12 | US | West Virginia | Pendleton | 54071 | 1998 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-13 04:20:51 | Pendleton, West Virginia, US | |
3265289 | 3265289 | 2022-05-04 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-05 04:20:55 | Hebei, China | |||
1571928 | 1571928 | 2022-05-03 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-04 04:20:59 | Hebei, China | |||
463188 | 463188 | 2022-05-02 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-03 04:21:00 | Hebei, China | |||
3915827 | 3915827 | 2022-05-01 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-02 04:21:10 | Hebei, China | |||
2840631 | 2840631 | 2022-04-30 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-01 04:20:57 | Hebei, China | |||
1156944 | 1156944 | 2022-04-29 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-30 04:21:05 | Hebei, China | |||
1696126 | 1696126 | 2022-04-28 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-29 04:20:59 | Hebei, China | |||
3851609 | 3851609 | 2022-04-27 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-28 04:20:47 | Hebei, China | |||
1329582 | 1329582 | 2022-04-26 | US | Virginia | Fairfax City | 51600 | 1998 | 43 | 0 | 38.85157547 | -77.29779640000002 | 2022-04-27 04:20:52 | Fairfax City, Virginia, US | |
3725536 | 3725536 | 2022-04-25 | US | Virginia | Fairfax City | 51600 | 1998 | 43 | 0 | 38.85157547 | -77.29779640000002 | 2022-04-26 04:20:51 | Fairfax City, Virginia, US | |
3439573 | 3439573 | 2022-04-22 | US | Puerto Rico | Guayanilla | 72059 | 1998 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-23 04:20:50 | Guayanilla, Puerto Rico, US | |
3436639 | 3436639 | 2022-04-22 | China | Sichuan | 1998 | 3 | 0 | 30.6171 | 102.7103 | 2022-04-23 04:20:50 | Sichuan, China | |||
2895728 | 2895728 | 2022-04-21 | US | Virginia | Buena Vista | 51530 | 1998 | 43 | 0 | 37.73484642 | -79.35296097 | 2022-04-22 04:20:45 | Buena Vista, Virginia, US | |
3420436 | 3420436 | 2022-04-17 | US | West Virginia | Tucker | 54093 | 1998 | 37 | 0 | 39.11240885 | -79.57053576 | 2022-04-18 04:21:12 | Tucker, West Virginia, US | |
307385 | 307385 | 2022-04-16 | US | West Virginia | Tucker | 54093 | 1998 | 37 | 0 | 39.11240885 | -79.57053576 | 2022-04-17 04:20:59 | Tucker, West Virginia, US | |
2673330 | 2673330 | 2022-04-15 | US | West Virginia | Tucker | 54093 | 1998 | 37 | 0 | 39.11240885 | -79.57053576 | 2022-04-16 04:20:48 | Tucker, West Virginia, US | |
1227115 | 1227115 | 2022-04-14 | US | West Virginia | Tucker | 54093 | 1998 | 37 | 0 | 39.11240885 | -79.57053576 | 2022-04-15 04:20:57 | Tucker, West Virginia, US | |
2446273 | 2446273 | 2022-04-13 | US | West Virginia | Tucker | 54093 | 1998 | 37 | 0 | 39.11240885 | -79.57053576 | 2022-04-13 23:21:06 | Tucker, West Virginia, US | |
3208473 | 3208473 | 2022-04-11 | US | New Mexico | Quay | 35037 | 1998 | 51 | 0 | 35.10403332 | -103.54817270000001 | 2022-04-12 04:20:49 | Quay, New Mexico, US | |
3323576 | 3323576 | 2022-04-07 | US | Virginia | Falls Church | 51610 | 1998 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-04-08 04:20:48 | Falls Church, Virginia, US | |
1543272 | 1543272 | 2022-03-31 | US | Virginia | Buena Vista | 51530 | 1998 | 43 | 0 | 37.73484642 | -79.35296097 | 2022-04-01 04:20:28 | Buena Vista, Virginia, US | |
1720282 | 1720282 | 2022-03-25 | China | Jiangsu | 1998 | 0 | 0 | 32.9711 | 119.455 | 2022-03-26 04:20:23 | Jiangsu, China | |||
27714 | 27714 | 2022-03-20 | US | Virginia | Buena Vista | 51530 | 1998 | 40 | 0 | 37.73484642 | -79.35296097 | 2022-03-21 04:20:50 | Buena Vista, Virginia, US | |
1659724 | 1659724 | 2022-03-19 | US | Virginia | Buena Vista | 51530 | 1998 | 40 | 0 | 37.73484642 | -79.35296097 | 2022-03-20 04:20:45 | Buena Vista, Virginia, US | |
339250 | 339250 | 2022-03-18 | US | Virginia | Buena Vista | 51530 | 1998 | 40 | 0 | 37.73484642 | -79.35296097 | 2022-03-19 04:20:47 | Buena Vista, Virginia, US | |
1865293 | 1865293 | 2022-03-10 | China | Yunnan | 1998 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-11 04:20:50 | Yunnan, China | |||
2143681 | 2143681 | 2022-03-09 | US | West Virginia | Pocahontas | 54075 | 1998 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-10 04:20:48 | Pocahontas, West Virginia, US | |
923192 | 923192 | 2022-03-08 | US | West Virginia | Pocahontas | 54075 | 1998 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-09 04:20:59 | Pocahontas, West Virginia, US | |
2668745 | 2668745 | 2022-03-04 | US | Tennessee | Hancock | 47067 | 1998 | 32 | 0 | 36.52692871 | -83.22375847 | 2022-03-05 04:21:10 | Hancock, Tennessee, US | |
1647310 | 1647310 | 2022-03-03 | US | Tennessee | Hancock | 47067 | 1998 | 32 | 0 | 36.52692871 | -83.22375847 | 2022-03-04 04:21:09 | Hancock, Tennessee, US | |
2528313 | 2528313 | 2022-03-02 | US | Tennessee | Hancock | 47067 | 1998 | 32 | 0 | 36.52692871 | -83.22375847 | 2022-03-03 04:21:01 | Hancock, Tennessee, US | |
1995607 | 1995607 | 2022-03-01 | US | Tennessee | Hancock | 47067 | 1998 | 32 | 0 | 36.52692871 | -83.22375847 | 2022-03-02 04:21:07 | Hancock, Tennessee, US | |
1058205 | 1058205 | 2022-02-23 | US | Alabama | Choctaw | 1023 | 1998 | 34 | 0 | 32.02227341 | -88.26564429999998 | 2022-02-24 04:21:14 | Choctaw, Alabama, US | |
2448761 | 2448761 | 2022-02-22 | US | Montana | Carbon | 30009 | 1998 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-23 04:21:09 | Carbon, Montana, US | |
2448165 | 2448165 | 2022-02-22 | US | Kentucky | Crittenden | 21055 | 1998 | 42 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-23 04:21:09 | Crittenden, Kentucky, US | |
1299668 | 1299668 | 2022-02-17 | US | Michigan | Baraga | 26013 | 1998 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-02-18 04:21:04 | Baraga, Michigan, US | |
3822054 | 3822054 | 2022-02-16 | US | Michigan | Baraga | 26013 | 1998 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-02-17 04:20:56 | Baraga, Michigan, US | |
3672855 | 3672855 | 2022-02-15 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-16 04:21:10 | Howard, Iowa, US | |
2645124 | 2645124 | 2022-02-14 | US | Virginia | Madison | 51113 | 1998 | 34 | 0 | 38.41531222 | -78.28220331 | 2022-02-15 04:21:09 | Madison, Virginia, US | |
2642956 | 2642956 | 2022-02-14 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-15 04:21:09 | Howard, Iowa, US | |
187273 | 187273 | 2022-02-13 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-14 04:20:51 | Howard, Iowa, US | |
317119 | 317119 | 2022-02-12 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-13 04:21:00 | Howard, Iowa, US | |
234445 | 234445 | 2022-02-11 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-12 04:21:06 | Howard, Iowa, US | |
1465287 | 1465287 | 2022-02-10 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-11 04:21:09 | Howard, Iowa, US | |
1464967 | 1464967 | 2022-02-10 | US | Georgia | Terrell | 13273 | 1998 | 60 | 0 | 31.77527543 | -84.44069698 | 2022-02-11 04:21:09 | Terrell, Georgia, US | |
1464610 | 1464610 | 2022-02-10 | US | Arkansas | Searcy | 5129 | 1998 | 40 | 0 | 35.9109364 | -92.69936482 | 2022-02-11 04:21:09 | Searcy, Arkansas, US | |
3076131 | 3076131 | 2022-02-09 | US | Nebraska | Holt | 31089 | 1998 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-02-10 04:21:14 | Holt, Nebraska, US | |
3075248 | 3075248 | 2022-02-09 | US | Iowa | Howard | 19089 | 1998 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-10 04:21:14 | Howard, Iowa, US | |
1296749 | 1296749 | 2022-02-05 | US | Puerto Rico | Adjuntas | 72001 | 1998 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-02-06 04:21:00 | Adjuntas, Puerto Rico, US | |
3063912 | 3063912 | 2022-01-29 | US | Missouri | Iron | 29093 | 1998 | 33 | 0 | 37.55487945 | -90.7735296 | 2022-01-30 04:21:26 | Iron, Missouri, US | |
1780713 | 1780713 | 2022-01-27 | US | Kansas | Norton | 20137 | 1998 | 35 | 0 | 39.78443827 | -99.90286639 | 2022-01-28 04:21:09 | Norton, Kansas, US | |
1320648 | 1320648 | 2022-01-26 | US | North Dakota | Traill | 38097 | 1998 | 22 | 0 | 47.45367788 | -97.16323288 | 2022-01-27 04:21:19 | Traill, North Dakota, US | |
1319541 | 1319541 | 2022-01-26 | US | Kansas | Norton | 20137 | 1998 | 35 | 0 | 39.78443827 | -99.90286639 | 2022-01-27 04:21:19 | Norton, Kansas, US | |
3615915 | 3615915 | 2022-01-12 | US | South Dakota | Bon Homme | 46009 | 1998 | 31 | 0 | 42.98914167 | -97.88592746 | 2022-01-13 08:00:09 | Bon Homme, South Dakota, US | |
3613086 | 3613086 | 2022-01-12 | Japan | Shimane | 1998 | 5 | 0 | 35.07076 | 132.55406399999998 | 2022-01-13 08:00:09 | Shimane, Japan | |||
1287321 | 1287321 | 2022-01-04 | US | Kansas | Marshall | 20117 | 1998 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-05 04:21:59 | Marshall, Kansas, US | |
1701665 | 1701665 | 2022-01-03 | US | Kansas | Marshall | 20117 | 1998 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-04 04:22:17 | Marshall, Kansas, US | |
1701421 | 1701421 | 2022-01-03 | US | Indiana | Brown | 18013 | 1998 | 51 | 0 | 39.19605589 | -86.22868909 | 2022-01-04 04:22:17 | Brown, Indiana, US | |
3519794 | 3519794 | 2022-01-02 | US | Alabama | Conecuh | 1035 | 1998 | 62 | 0 | 31.43401703 | -86.99320044 | 2022-01-03 02:22:25 | Conecuh, Alabama, US | |
1671707 | 1671707 | 2021-12-29 | US | Texas | Ward | 48475 | 1998 | 35 | 0 | 31.50999644 | -103.09279090000001 | 2021-12-30 04:21:25 | Ward, Texas, US | |
3831819 | 3831819 | 2021-12-21 | US | Virginia | Greensville | 51081 | 1998 | 27 | 0 | 36.67878901 | -77.56351439 | 2021-12-22 04:21:54 | Greensville, Virginia, US | |
1254588 | 1254588 | 2021-12-20 | China | Zhejiang | 1998 | 1 | 0 | 29.1832 | 120.0934 | 2021-12-21 03:21:27 | Zhejiang, China | |||
1716885 | 1716885 | 2021-12-16 | US | Arkansas | Stone | 5137 | 1998 | 46 | 0 | 35.86251946 | -92.15684085 | 2021-12-17 04:22:14 | Stone, Arkansas, US | |
2088544 | 2088544 | 2021-12-14 | US | California | Plumas | 6063 | 1998 | 12 | 0 | 40.00355989 | -120.8395236 | 2021-12-15 03:22:16 | Plumas, California, US | |
785147 | 785147 | 2021-12-13 | US | Puerto Rico | Las Piedras | 72085 | 1998 | 0 | 0 | 18.187527 | -65.86946800000001 | 2021-12-14 04:22:38 | Las Piedras, Puerto Rico, US | |
1663182 | 1663182 | 2021-12-12 | US | Puerto Rico | Las Piedras | 72085 | 1998 | 0 | 0 | 18.187527 | -65.86946800000001 | 2021-12-13 04:22:02 | Las Piedras, Puerto Rico, 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]);