johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where confirmed = 175, country_or_region = "US" and province_or_state = "Montana" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1694318 | 1694318 | 2022-01-10 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-11 04:22:01 | Garfield, Montana, US | |
128733 | 128733 | 2022-01-09 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-10 04:22:07 | Garfield, Montana, US | |
1217568 | 1217568 | 2022-01-08 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-09 04:21:46 | Garfield, Montana, US | |
1391661 | 1391661 | 2022-01-07 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-08 04:21:53 | Garfield, Montana, US | |
2612048 | 2612048 | 2022-01-06 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-07 04:22:09 | Garfield, Montana, US | |
1283990 | 1283990 | 2022-01-05 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-06 04:22:09 | Garfield, Montana, US | |
1288006 | 1288006 | 2022-01-04 | US | Montana | Garfield | 30033 | 175 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-05 04:21:59 | Garfield, Montana, US | |
3403480 | 3403480 | 2021-11-30 | US | Montana | Wibaux | 30109 | 175 | 8 | 0 | 46.95925154 | -104.2510927 | 2021-12-01 04:22:29 | Wibaux, Montana, US | |
152023 | 152023 | 2021-11-29 | US | Montana | Wibaux | 30109 | 175 | 8 | 0 | 46.95925154 | -104.2510927 | 2021-11-30 04:22:53 | Wibaux, Montana, US | |
1233669 | 1233669 | 2021-11-28 | US | Montana | Wibaux | 30109 | 175 | 8 | 0 | 46.95925154 | -104.2510927 | 2021-11-29 04:22:30 | Wibaux, Montana, US | |
1360376 | 1360376 | 2021-11-27 | US | Montana | Wibaux | 30109 | 175 | 8 | 0 | 46.95925154 | -104.2510927 | 2021-11-28 04:22:43 | Wibaux, Montana, US | |
760367 | 760367 | 2021-11-26 | US | Montana | Wibaux | 30109 | 175 | 8 | 0 | 46.95925154 | -104.2510927 | 2021-11-27 04:22:45 | Wibaux, Montana, US | |
1804768 | 1804768 | 2021-11-25 | US | Montana | Prairie | 30079 | 175 | 2 | 0 | 46.86048047 | -105.379384 | 2021-11-26 04:22:33 | Prairie, Montana, US | |
906202 | 906202 | 2021-11-24 | US | Montana | Prairie | 30079 | 175 | 2 | 0 | 46.86048047 | -105.379384 | 2021-11-25 04:22:33 | Prairie, Montana, US | |
3072052 | 3072052 | 2021-11-23 | US | Montana | Prairie | 30079 | 175 | 2 | 0 | 46.86048047 | -105.379384 | 2021-11-24 04:22:14 | Prairie, Montana, US | |
3751150 | 3751150 | 2021-11-22 | US | Montana | Prairie | 30079 | 175 | 2 | 0 | 46.86048047 | -105.379384 | 2021-11-23 04:22:39 | Prairie, Montana, US | |
243285 | 243285 | 2021-04-02 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-04-03 04:20:44 | Wheatland, Montana, US | |
1304080 | 1304080 | 2021-04-01 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-04-02 04:20:36 | Wheatland, Montana, US | |
639952 | 639952 | 2021-03-31 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-04-01 04:27:05 | Wheatland, Montana, US | |
3645581 | 3645581 | 2021-03-30 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-31 04:26:25 | Wheatland, Montana, US | |
1292034 | 1292034 | 2021-03-29 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-30 04:26:23 | Wheatland, Montana, US | |
1537956 | 1537956 | 2021-03-28 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-29 04:28:35 | Wheatland, Montana, US | |
1221596 | 1221596 | 2021-03-27 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-28 05:28:10 | Wheatland, Montana, US | |
1883014 | 1883014 | 2021-03-26 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-27 05:25:04 | Wheatland, Montana, US | |
1982644 | 1982644 | 2021-03-25 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-26 05:26:55 | Wheatland, Montana, US | |
2783022 | 2783022 | 2021-03-24 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-25 05:27:00 | Wheatland, Montana, US | |
1800667 | 1800667 | 2021-03-23 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-24 05:25:40 | Wheatland, Montana, US | |
1205835 | 1205835 | 2021-03-22 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-23 05:26:18 | Wheatland, Montana, US | |
3371357 | 3371357 | 2021-03-21 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-22 05:25:43 | Wheatland, Montana, US | |
1746567 | 1746567 | 2021-03-20 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-21 05:25:44 | Wheatland, Montana, US | |
3422947 | 3422947 | 2021-03-19 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-20 05:25:46 | Wheatland, Montana, US | |
3454885 | 3454885 | 2021-03-18 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-19 05:26:09 | Wheatland, Montana, US | |
3623109 | 3623109 | 2021-03-17 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-18 05:26:22 | Wheatland, Montana, US | |
704433 | 704433 | 2021-03-16 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-17 05:25:07 | Wheatland, Montana, US | |
2057911 | 2057911 | 2021-03-15 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-16 05:25:13 | Wheatland, Montana, US | |
1734523 | 1734523 | 2021-03-14 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-15 05:25:51 | Wheatland, Montana, US | |
1582180 | 1582180 | 2021-03-13 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-14 05:25:37 | Wheatland, Montana, US | |
1839959 | 1839959 | 2021-03-12 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-13 05:25:15 | Wheatland, Montana, US | |
354324 | 354324 | 2021-03-11 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-12 05:26:50 | Wheatland, Montana, US | |
3964548 | 3964548 | 2021-03-10 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-11 05:25:48 | Wheatland, Montana, US | |
3665636 | 3665636 | 2021-03-09 | US | Montana | Wheatland | 30107 | 175 | 7 | 0 | 46.46652491 | -109.8464636 | 2021-03-10 05:24:35 | Wheatland, Montana, US | |
1155123 | 1155123 | 2021-02-18 | US | Montana | McCone | 30055 | 175 | 0 | 0 | 175 | 47.64469406 | -105.7944994 | 2021-02-19 05:24:16 | McCone, Montana, US |
866749 | 866749 | 2020-11-12 | US | Montana | Chouteau | 30015 | 175 | 0 | 0 | 175 | 47.88084126 | -110.4353362 | 2020-11-13 05:25:30 | Chouteau, Montana, US |
3803903 | 3803903 | 2020-10-05 | US | Montana | Ravalli | 30081 | 175 | 2 | 0 | 173 | 46.08520862 | -114.11891640000002 | 2020-10-06 04:23:33 | Ravalli, Montana, US |
2850823 | 2850823 | 2020-09-18 | US | Montana | Glacier | 30035 | 175 | 1 | 0 | 174 | 48.70513576 | -112.9934235 | 2020-09-19 04:22:00 | Glacier, Montana, 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]);