johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

755 rows where confirmed = 437 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 11

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2138200 2138200 2022-12-01 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-12-02 04:21:07 Wheatland, Montana, US
1966616 1966616 2022-11-30 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-12-01 04:21:03 Wheatland, Montana, US
2558630 2558630 2022-11-29 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-11-30 04:21:07 Wheatland, Montana, US
1241704 1241704 2022-11-28 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-11-29 04:21:05 Wheatland, Montana, US
3553692 3553692 2022-11-27 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-11-28 04:21:02 Wheatland, Montana, US
2102172 2102172 2022-11-26 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-11-27 04:21:05 Wheatland, Montana, US
489663 489663 2022-11-25 US Montana Wheatland 30107 437 14 0   46.46652491 -109.8464636 2022-11-26 04:21:11 Wheatland, Montana, US
2273921 2273921 2022-10-20 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-21 04:22:23 Daniels, Montana, US
200256 200256 2022-10-19 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-20 04:22:59 Daniels, Montana, US
2758917 2758917 2022-10-18 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-19 04:22:26 Daniels, Montana, US
2026751 2026751 2022-10-17 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-18 04:22:42 Daniels, Montana, US
2161529 2161529 2022-10-16 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-17 04:20:31 Daniels, Montana, US
517726 517726 2022-10-15 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-16 04:22:39 Daniels, Montana, US
2034783 2034783 2022-10-14 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-15 04:22:00 Daniels, Montana, US
3755471 3755471 2022-10-13 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-14 04:22:28 Daniels, Montana, US
3216296 3216296 2022-10-12 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-13 04:22:39 Daniels, Montana, US
3252145 3252145 2022-10-11 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-12 04:22:51 Daniels, Montana, US
2969404 2969404 2022-10-10 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-11 04:23:05 Daniels, Montana, US
3099440 3099440 2022-10-09 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-10 04:22:32 Daniels, Montana, US
4004665 4004665 2022-10-08 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-09 04:21:16 Daniels, Montana, US
398262 398262 2022-10-07 US Montana Daniels 30019 437 9 0   48.78420029 -105.5476343 2022-10-08 04:22:56 Daniels, Montana, US
2635804 2635804 2022-09-05 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-06 04:21:02 Greeley, Nebraska, US
2989368 2989368 2022-09-04 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-05 04:21:01 Greeley, Nebraska, US
2715053 2715053 2022-09-03 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-04 04:21:22 Greeley, Nebraska, US
1395758 1395758 2022-09-02 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-03 04:21:04 Greeley, Nebraska, US
3549587 3549587 2022-09-01 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-02 04:21:07 Greeley, Nebraska, US
2345507 2345507 2022-08-31 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-09-01 04:21:03 Greeley, Nebraska, US
3775987 3775987 2022-08-30 US Nebraska Greeley 31077 437 2 0   41.56742671 -98.52150266 2022-08-31 04:20:57 Greeley, Nebraska, US
1254115 1254115 2022-08-23 US Virginia Highland 51091 437 6 0   38.35799465 -79.56124594 2022-08-24 04:20:46 Highland, Virginia, US
2856219 2856219 2022-08-22 US Virginia Highland 51091 437 6 0   38.35799465 -79.56124594 2022-08-23 04:20:56 Highland, Virginia, US
2406191 2406191 2022-08-21 US Virginia Highland 51091 437 7 0   38.35799465 -79.56124594 2022-08-22 04:20:38 Highland, Virginia, US
3801269 3801269 2022-08-20 US Virginia Highland 51091 437 7 0   38.35799465 -79.56124594 2022-08-21 04:20:44 Highland, Virginia, US
2366855 2366855 2022-08-19 US Virginia Highland 51091 437 7 0   38.35799465 -79.56124594 2022-08-20 04:21:01 Highland, Virginia, US
1088148 1088148 2022-08-09 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-10 04:20:57 Franklin, Nebraska, US
3545563 3545563 2022-08-08 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-09 04:20:34 Franklin, Nebraska, US
1071966 1071966 2022-08-07 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-08 04:21:08 Franklin, Nebraska, US
1942554 1942554 2022-08-06 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-07 04:20:54 Franklin, Nebraska, US
882353 882353 2022-08-05 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-06 04:20:56 Franklin, Nebraska, US
2010764 2010764 2022-08-04 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-05 04:20:52 Franklin, Nebraska, US
1100191 1100191 2022-08-03 US Nebraska Franklin 31061 437 12 0   40.17636348 -98.95299073 2022-08-04 04:20:58 Franklin, Nebraska, US
631262 631262 2022-07-12 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-13 04:20:58 Stanton, Kansas, US
1212906 1212906 2022-07-11 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-12 04:20:51 Stanton, Kansas, US
2790388 2790388 2022-07-10 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-11 04:20:46 Stanton, Kansas, US
143341 143341 2022-07-09 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-10 04:20:54 Stanton, Kansas, US
1418441 1418441 2022-07-08 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-09 04:20:59 Stanton, Kansas, US
2742366 2742366 2022-07-07 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-08 04:20:56 Stanton, Kansas, US
1201161 1201161 2022-07-06 US Kansas Stanton 20187 437 9 0   37.56304714 -101.7843534 2022-07-07 04:20:55 Stanton, Kansas, US
3080250 3080250 2022-07-04 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-07-05 04:20:45 Catron, New Mexico, US
1769532 1769532 2022-07-03 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-07-04 04:20:54 Catron, New Mexico, US
3367518 3367518 2022-07-02 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-07-03 04:20:59 Catron, New Mexico, US
595847 595847 2022-07-01 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-07-02 04:21:16 Catron, New Mexico, US
3942248 3942248 2022-06-30 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-07-01 04:21:10 Catron, New Mexico, US
2492206 2492206 2022-06-29 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-06-30 04:21:01 Catron, New Mexico, US
2241588 2241588 2022-06-28 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-06-29 04:20:59 Catron, New Mexico, US
2149830 2149830 2022-06-27 US New Mexico Catron 35003 437 15 0   33.91514144 -108.4046587 2022-06-28 04:20:58 Catron, New Mexico, US
3160029 3160029 2022-06-09 US North Dakota Burke 38013 437 3 0   48.79094471 -102.5182117 2022-06-10 04:20:55 Burke, North Dakota, US
1423496 1423496 2022-06-08 US North Dakota Burke 38013 437 3 0   48.79094471 -102.5182117 2022-06-09 04:20:54 Burke, North Dakota, US
230587 230587 2022-05-31 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-06-01 04:20:55 Wallace, Kansas, US
3187352 3187352 2022-05-30 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-31 04:20:51 Wallace, Kansas, US
3199501 3199501 2022-05-29 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-30 04:20:50 Wallace, Kansas, US
2726379 2726379 2022-05-28 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-29 04:20:53 Wallace, Kansas, US
1315560 1315560 2022-05-27 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-28 04:21:07 Wallace, Kansas, US
1851352 1851352 2022-05-26 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-27 04:20:56 Wallace, Kansas, US
2049228 2049228 2022-05-25 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-26 04:20:50 Wallace, Kansas, US
623239 623239 2022-05-22 US Kansas Wallace 20199 437 7 0   38.91686134 -101.7638876 2022-05-26 04:20:50 Wallace, Kansas, US
1327148 1327148 2022-04-26 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-27 04:20:52 Webster, Georgia, US
3723102 3723102 2022-04-25 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-26 04:20:51 Webster, Georgia, US
2029670 2029670 2022-04-24 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-25 04:20:56 Webster, Georgia, US
747245 747245 2022-04-23 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-24 04:20:56 Webster, Georgia, US
3437730 3437730 2022-04-22 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-23 04:20:50 Webster, Georgia, US
2893315 2893315 2022-04-21 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-22 04:20:45 Webster, Georgia, US
2308187 2308187 2022-04-20 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-21 04:20:46 Webster, Georgia, US
2252326 2252326 2022-04-19 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-20 04:20:45 Webster, Georgia, US
1846876 1846876 2022-04-18 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-19 04:21:00 Webster, Georgia, US
3417820 3417820 2022-04-17 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-18 04:21:12 Webster, Georgia, US
304769 304769 2022-04-16 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-17 04:20:59 Webster, Georgia, US
2670714 2670714 2022-04-15 US Georgia Webster 13307 437 8 0   32.04066113 -84.54742852 2022-04-16 04:20:48 Webster, Georgia, US
1994012 1994012 2022-03-01 US Kansas Stanton 20187 437 9 0   37.56304714 -101.78435340000001 2022-03-02 04:21:07 Stanton, Kansas, US
944186 944186 2022-02-28 US Kansas Stanton 20187 437 9 0   37.56304714 -101.78435340000001 2022-03-01 04:21:09 Stanton, Kansas, US
2448047 2448047 2022-02-22 US Kansas Comanche 20033 437 14 0   37.19114520000001 -99.27113247 2022-02-23 04:21:09 Comanche, Kansas, US
3719460 3719460 2022-02-21 US Kansas Comanche 20033 437 14 0   37.19114520000001 -99.27113247 2022-02-22 04:21:01 Comanche, Kansas, US
3823472 3823472 2022-02-16 US Texas Briscoe 48045 437 8 0   34.53026962 -101.2084947 2022-02-17 04:20:56 Briscoe, Texas, US
3674686 3674686 2022-02-15 US Texas Briscoe 48045 437 8 0   34.53026962 -101.2084947 2022-02-16 04:21:10 Briscoe, Texas, US
2643028 2643028 2022-02-14 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-15 04:21:09 Comanche, Kansas, US
187345 187345 2022-02-13 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-14 04:20:51 Comanche, Kansas, US
317191 317191 2022-02-12 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-13 04:21:00 Comanche, Kansas, US
234517 234517 2022-02-11 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-12 04:21:06 Comanche, Kansas, US
1465359 1465359 2022-02-10 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-11 04:21:09 Comanche, Kansas, US
3075320 3075320 2022-02-09 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-10 04:21:14 Comanche, Kansas, US
1363627 1363627 2022-02-08 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-09 04:21:04 Comanche, Kansas, US
72365 72365 2022-02-07 US Kansas Comanche 20033 437 13 0   37.19114520000001 -99.27113247 2022-02-08 04:21:15 Comanche, Kansas, US
982028 982028 2022-02-01 US Texas Edwards 48137 437 10 0   29.98202582 -100.304252 2022-02-02 04:21:09 Edwards, Texas, US
2660194 2660194 2022-01-31 US North Dakota Grant 38037 437 11 0   46.35821257 -101.63900129999999 2022-02-01 04:21:11 Grant, North Dakota, US
2054643 2054643 2022-01-25 US Puerto Rico Maricao 72093 437 0 0   18.171795 -66.942126 2022-01-26 04:21:07 Maricao, Puerto Rico, US
2053178 2053178 2022-01-25 US Kansas Hamilton 20075 437 3 0   37.99978709 -101.7921066 2022-01-26 04:21:07 Hamilton, Kansas, US
1228909 1228909 2022-01-24 US Kansas Hamilton 20075 437 3 0   37.99978709 -101.7921066 2022-01-25 04:21:05 Hamilton, Kansas, US
102342 102342 2022-01-14 US Texas Armstrong 48011 437 8 0   34.96507426 -101.35748740000001 2022-01-15 04:21:07 Armstrong, Texas, US
1703231 1703231 2022-01-03 US South Dakota Jackson 46071 437 19 0   43.69318385 -101.6255063 2022-01-04 04:22:17 Jackson, South Dakota, US
3522314 3522314 2022-01-02 US South Dakota Jackson 46071 437 19 0   43.69318385 -101.6255063 2022-01-03 02:22:25 Jackson, South Dakota, US
2170444 2170444 2022-01-01 US South Dakota Jackson 46071 437 19 0   43.69318385 -101.6255063 2022-01-02 04:20:52 Jackson, South Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);