johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 15271 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 16
- Oklahoma 7
- New York 4
- Illinois 3
- Louisiana 3
- North Carolina 3
- Arkansas 2
- Texas 2
- Alabama 1
- Massachusetts 1
- Minnesota 1
- New Jersey 1
- Ohio 1
- Puerto Rico 1
- South Dakota 1
- Tennessee 1
- Virginia 1
country_or_region 1
- US · 33 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
871519 | 871519 | 2022-12-11 | US | Puerto Rico | Aguadilla | 72005 | 15271 | 0 | 0 | 18.459681 | -67.120815 | 2022-12-12 04:21:01 | Aguadilla, Puerto Rico, US | |
2760279 | 2760279 | 2022-10-18 | US | Virginia | Henry | 51089 | 15271 | 297 | 0 | 36.68542395 | -79.87634026 | 2022-10-19 04:22:26 | Henry, Virginia, US | |
1978167 | 1978167 | 2022-09-25 | US | Louisiana | Washington | 22117 | 15271 | 264 | 0 | 30.85288548 | -90.03866652 | 2022-09-26 04:20:52 | Washington, Louisiana, US | |
2651334 | 2651334 | 2022-09-24 | US | Louisiana | Washington | 22117 | 15271 | 264 | 0 | 30.85288548 | -90.03866652 | 2022-09-25 04:23:31 | Washington, Louisiana, US | |
385774 | 385774 | 2022-09-23 | US | Louisiana | Washington | 22117 | 15271 | 264 | 0 | 30.85288548 | -90.03866652 | 2022-09-24 04:21:40 | Washington, Louisiana, US | |
372709 | 372709 | 2022-09-13 | US | Arkansas | Mississippi | 5093 | 15271 | 221 | 0 | 35.76271485 | -90.0519437 | 2022-09-14 04:20:44 | Mississippi, Arkansas, US | |
2635963 | 2635963 | 2022-09-05 | US | New York | Genesee | 36037 | 15271 | 198 | 0 | 43.0022601 | -78.19135193 | 2022-09-06 04:21:02 | Genesee, New York, US | |
1879234 | 1879234 | 2022-08-28 | US | New York | Madison | 36053 | 15271 | 132 | 0 | 42.91653905 | -75.67266639 | 2022-08-29 04:21:06 | Madison, New York, US | |
2337936 | 2337936 | 2022-07-27 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-28 04:20:56 | Carter, Oklahoma, US | |
1490126 | 1490126 | 2022-07-26 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-27 04:21:04 | Carter, Oklahoma, US | |
2596572 | 2596572 | 2022-07-25 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-26 04:20:58 | Carter, Oklahoma, US | |
897180 | 897180 | 2022-07-24 | US | Illinois | Ogle | 17141 | 15271 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-07-25 04:20:51 | Ogle, Illinois, US | |
898687 | 898687 | 2022-07-24 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-25 04:20:51 | Carter, Oklahoma, US | |
92174 | 92174 | 2022-07-23 | US | Illinois | Ogle | 17141 | 15271 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-07-24 04:20:47 | Ogle, Illinois, US | |
93681 | 93681 | 2022-07-23 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-24 04:20:47 | Carter, Oklahoma, US | |
901196 | 901196 | 2022-07-22 | US | Illinois | Ogle | 17141 | 15271 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-07-23 04:20:53 | Ogle, Illinois, US | |
902703 | 902703 | 2022-07-22 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-23 04:20:53 | Carter, Oklahoma, US | |
672839 | 672839 | 2022-07-21 | US | Oklahoma | Carter | 40019 | 15271 | 242 | 0 | 34.25103751 | -97.28552485 | 2022-07-22 04:21:15 | Carter, Oklahoma, US | |
3984318 | 3984318 | 2022-06-15 | US | Minnesota | Chisago | 27025 | 15271 | 120 | 0 | 45.5021011 | -92.90861945 | 2022-06-16 04:20:55 | Chisago, Minnesota, US | |
2322346 | 2322346 | 2022-03-16 | US | Texas | Angelina | 48005 | 15271 | 476 | 0 | 31.25457347 | -94.60901487 | 2022-03-17 04:20:56 | Angelina, Texas, US | |
264546 | 264546 | 2022-03-15 | US | Texas | Angelina | 48005 | 15271 | 475 | 0 | 31.25457347 | -94.60901487 | 2022-03-16 04:20:50 | Angelina, Texas, US | |
73978 | 73978 | 2022-02-07 | US | South Dakota | Lincoln | 46083 | 15271 | 91 | 0 | 43.27841182 | -96.72039050000001 | 2022-02-08 04:21:15 | Lincoln, South Dakota, US | |
2015043 | 2015043 | 2022-02-06 | US | North Carolina | Lee | 37105 | 15271 | 129 | 0 | 35.47623147 | -79.17569362 | 2022-02-07 04:21:05 | Lee, North Carolina, US | |
1296372 | 1296372 | 2022-02-05 | US | North Carolina | Lee | 37105 | 15271 | 129 | 0 | 35.47623147 | -79.17569362 | 2022-02-06 04:21:00 | Lee, North Carolina, US | |
2329700 | 2329700 | 2022-02-04 | US | North Carolina | Lee | 37105 | 15271 | 129 | 0 | 35.47623147 | -79.17569362 | 2022-02-05 04:21:05 | Lee, North Carolina, US | |
3794263 | 3794263 | 2021-10-25 | US | Alabama | Elmore | 1051 | 15271 | 286 | 0 | 32.59785413 | -86.14415284 | 2021-10-26 04:22:09 | Elmore, Alabama, US | |
1777629 | 1777629 | 2021-08-30 | US | New York | Ulster | 36111 | 15271 | 263 | 0 | 41.89027881 | -74.26252104 | 2021-08-31 04:21:46 | Ulster, New York, US | |
3128422 | 3128422 | 2021-06-28 | US | Tennessee | Bradley | 47011 | 15271 | 152 | 0 | 35.15739424 | -84.857186 | 2021-06-29 04:21:28 | Bradley, Tennessee, US | |
3032751 | 3032751 | 2021-06-16 | US | Ohio | Greene | 39057 | 15271 | 254 | 0 | 39.69116283 | -83.89032084 | 2021-06-17 04:22:36 | Greene, Ohio, US | |
1809003 | 1809003 | 2021-05-27 | US | New York | Saratoga | 36091 | 15271 | 167 | 0 | 43.10904162 | -73.86653895 | 2021-05-28 04:20:36 | Saratoga, New York, US | |
727017 | 727017 | 2021-05-22 | US | Arkansas | Sebastian | 5131 | 15271 | 281 | 0 | 35.19605503 | -94.27162713 | 2021-05-23 04:20:51 | Sebastian, Arkansas, US | |
3861993 | 3861993 | 2020-12-04 | US | New Jersey | Mercer | 34021 | 15271 | 668 | 0 | 14603 | 40.28047017 | -74.70479631 | 2020-12-05 05:27:36 | Mercer, New Jersey, US |
1208346 | 1208346 | 2020-06-09 | US | Massachusetts | Essex | 25009 | 15271 | 1016 | 0 | 14255 | 42.6687626 | -70.94687179 | 2020-06-10 04:07:00 | Essex, Massachusetts, 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]);