johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where country_or_region = "US" and deaths = 2708 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 12
- Minnesota 7
- New York 7
- Missouri 4
- Michigan 3
- New Jersey 3
- Washington 3
- Arizona 2
- Texas 2
- California 1
- Florida 1
- Illinois 1
- Ohio 1
country_or_region 1
- US · 35 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1812502 | 1812502 | 2022-10-05 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-06 04:21:22 | Hennepin, Minnesota, US | |
132476 | 132476 | 2022-10-04 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-05 04:23:06 | Hennepin, Minnesota, US | |
2687423 | 2687423 | 2022-10-03 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-04 04:22:55 | Hennepin, Minnesota, US | |
2261490 | 2261490 | 2022-10-02 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-03 04:23:11 | Hennepin, Minnesota, US | |
2997016 | 2997016 | 2022-10-01 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-02 04:21:23 | Hennepin, Minnesota, US | |
855342 | 855342 | 2022-09-30 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-01 04:23:01 | Hennepin, Minnesota, US | |
2377268 | 2377268 | 2022-09-29 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-09-30 04:23:09 | Hennepin, Minnesota, US | |
2357936 | 2357936 | 2022-09-16 | US | Ohio | Franklin | 39049 | 338573 | 2708 | 0 | 39.96995815 | -83.01115755 | 2022-09-17 04:20:19 | Franklin, Ohio, US | |
1489822 | 1489822 | 2022-07-26 | US | New York | Erie | 36029 | 241261 | 2708 | 0 | 42.76249024 | -78.73063652 | 2022-07-27 04:21:04 | Erie, New York, US | |
2596268 | 2596268 | 2022-07-25 | US | New York | Erie | 36029 | 241118 | 2708 | 0 | 42.76249024 | -78.73063652 | 2022-07-26 04:20:58 | Erie, New York, US | |
1848257 | 1848257 | 2022-04-18 | US | New York | Westchester | 36119 | 255017 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-19 04:21:00 | Westchester, New York, US | |
3419201 | 3419201 | 2022-04-17 | US | New York | Westchester | 36119 | 254506 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-18 04:21:12 | Westchester, New York, US | |
3420366 | 3420366 | 2022-04-17 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-18 04:21:12 | King, Washington, US | |
306150 | 306150 | 2022-04-16 | US | New York | Westchester | 36119 | 254506 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-17 04:20:59 | Westchester, New York, US | |
307315 | 307315 | 2022-04-16 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-17 04:20:59 | King, Washington, US | |
2672095 | 2672095 | 2022-04-15 | US | New York | Westchester | 36119 | 254172 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-16 04:20:48 | Westchester, New York, US | |
2673260 | 2673260 | 2022-04-15 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-16 04:20:48 | King, Washington, US | |
3022822 | 3022822 | 2022-03-23 | US | California | Fresno | 6019 | 253736 | 2708 | 0 | 36.75733899 | -119.6466953 | 2022-03-24 04:20:43 | Fresno, California, US | |
263705 | 263705 | 2022-03-15 | US | New Jersey | Hudson | 34017 | 169428 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-16 04:20:50 | Hudson, New Jersey, US | |
2266064 | 2266064 | 2022-03-14 | US | New Jersey | Hudson | 34017 | 169369 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-15 04:20:47 | Hudson, New Jersey, US | |
358499 | 358499 | 2022-03-11 | US | New Jersey | Hudson | 34017 | 169267 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-12 04:20:50 | Hudson, New Jersey, US | |
3607040 | 3607040 | 2021-12-25 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-26 04:21:50 | St. Louis, Missouri, US | |
2965358 | 2965358 | 2021-12-24 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-25 04:21:37 | St. Louis, Missouri, US | |
3818390 | 3818390 | 2021-12-23 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-24 04:21:34 | St. Louis, Missouri, US | |
800398 | 800398 | 2021-12-22 | US | Missouri | St. Louis | 29189 | 144627 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-23 04:21:21 | St. Louis, Missouri, US | |
45367 | 45367 | 2021-11-02 | US | Michigan | Macomb | 26099 | 123374 | 2708 | 0 | 42.69158356 | -82.92752801 | 2021-11-03 06:22:09 | Macomb, Michigan, US | |
3513063 | 3513063 | 2021-11-01 | US | Michigan | Macomb | 26099 | 123374 | 2708 | 0 | 42.69158356 | -82.92752801 | 2021-11-02 04:22:03 | Macomb, Michigan, US | |
3794350 | 3794350 | 2021-10-25 | US | Arizona | Pima | 4019 | 141870 | 2708 | 0 | 32.0971334 | -111.7890033 | 2021-10-26 04:22:09 | Pima, Arizona, US | |
682796 | 682796 | 2021-10-24 | US | Arizona | Pima | 4019 | 141869 | 2708 | 0 | 32.0971334 | -111.7890033 | 2021-10-25 04:22:31 | Pima, Arizona, US | |
3833536 | 3833536 | 2021-10-05 | US | Illinois | Unassigned | 90017 | 279 | 2708 | 0 | 42.36542373 | 0.0 | 2021-10-06 04:21:33 | Unassigned, Illinois, US | |
2549595 | 2549595 | 2021-04-15 | US | Florida | Palm Beach | 12099 | 137552 | 2708 | 0 | 26.64676272 | -80.46536002 | 2021-04-16 04:20:46 | Palm Beach, Florida, US | |
2058991 | 2058991 | 2021-03-15 | US | Texas | Hidalgo | 48215 | 88412 | 2708 | 0 | 26.39418217 | -98.18299696 | 2021-03-16 05:25:13 | Hidalgo, Texas, US | |
2569926 | 2569926 | 2021-01-25 | US | New York | Suffolk | 36103 | 136593 | 2708 | 0 | 133885 | 40.88320119 | -72.8012172 | 2021-01-26 05:22:02 | Suffolk, New York, US |
789471 | 789471 | 2020-10-15 | US | Texas | Harris | 48201 | 192100 | 2708 | 0 | 150269 | 29.85864939 | -95.39339521 | 2020-10-16 04:24:01 | Harris, Texas, US |
2039433 | 2039433 | 2020-06-27 | US | Michigan | Wayne | 26163 | 22579 | 2708 | 0 | 19871 | 42.28098405 | -83.281255 | 2020-06-28 04:34:04 | Wayne, Michigan, 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]);