johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where country_or_region = "US", deaths = 221 and province_or_state = "New Mexico" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076119 | 1076119 | 2022-12-28 | US | New Mexico | Otero | 35035 | 16783 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-29 04:21:01 | Otero, New Mexico, US | |
330116 | 330116 | 2022-12-27 | US | New Mexico | Otero | 35035 | 16767 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-28 04:21:04 | Otero, New Mexico, US | |
220189 | 220189 | 2022-12-26 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-27 04:21:07 | Otero, New Mexico, US | |
3224646 | 3224646 | 2022-12-25 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-26 04:21:06 | Otero, New Mexico, US | |
1020560 | 1020560 | 2022-12-24 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-25 04:21:04 | Otero, New Mexico, US | |
692583 | 692583 | 2022-12-23 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-24 04:21:02 | Otero, New Mexico, US | |
993187 | 993187 | 2022-08-16 | US | New Mexico | Curry | 35009 | 14127 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-17 04:20:59 | Curry, New Mexico, US | |
2496226 | 2496226 | 2022-08-15 | US | New Mexico | Curry | 35009 | 14109 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-16 04:20:58 | Curry, New Mexico, US | |
3649776 | 3649776 | 2022-08-14 | US | New Mexico | Curry | 35009 | 14078 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-15 04:20:59 | Curry, New Mexico, US | |
1970782 | 1970782 | 2022-08-13 | US | New Mexico | Curry | 35009 | 14078 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-14 04:20:55 | Curry, New Mexico, US | |
2890591 | 2890591 | 2022-08-12 | US | New Mexico | Curry | 35009 | 14078 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-13 04:20:52 | Curry, New Mexico, US | |
3910196 | 3910196 | 2022-08-11 | US | New Mexico | Curry | 35009 | 14067 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-12 04:20:54 | Curry, New Mexico, US | |
1348513 | 1348513 | 2022-08-10 | US | New Mexico | Curry | 35009 | 14043 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-11 04:20:49 | Curry, New Mexico, US | |
1088268 | 1088268 | 2022-08-09 | US | New Mexico | Curry | 35009 | 14029 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-10 04:20:57 | Curry, New Mexico, US | |
3545683 | 3545683 | 2022-08-08 | US | New Mexico | Curry | 35009 | 14005 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-09 04:20:34 | Curry, New Mexico, US | |
1072086 | 1072086 | 2022-08-07 | US | New Mexico | Curry | 35009 | 13971 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-08 04:21:08 | Curry, New Mexico, US | |
1942674 | 1942674 | 2022-08-06 | US | New Mexico | Curry | 35009 | 13971 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-07 04:20:54 | Curry, New Mexico, US | |
882473 | 882473 | 2022-08-05 | US | New Mexico | Curry | 35009 | 13971 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-06 04:20:56 | Curry, New Mexico, US | |
2010884 | 2010884 | 2022-08-04 | US | New Mexico | Curry | 35009 | 13952 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-05 04:20:52 | Curry, New Mexico, US | |
1100311 | 1100311 | 2022-08-03 | US | New Mexico | Curry | 35009 | 13934 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-04 04:20:58 | Curry, New Mexico, US | |
1407236 | 1407236 | 2022-08-02 | US | New Mexico | Curry | 35009 | 13907 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-03 04:20:59 | Curry, New Mexico, US | |
3619274 | 3619274 | 2022-08-01 | US | New Mexico | Curry | 35009 | 13886 | 221 | 0 | 34.57421077 | -103.3468876 | 2022-08-02 04:20:53 | Curry, New Mexico, US | |
2113894 | 2113894 | 2021-12-26 | US | New Mexico | Eddy | 35015 | 12433 | 221 | 0 | 32.47167456 | -104.3053527 | 2021-12-27 04:21:58 | Eddy, New Mexico, US | |
3607266 | 3607266 | 2021-12-25 | US | New Mexico | Eddy | 35015 | 12433 | 221 | 0 | 32.47167456 | -104.3053527 | 2021-12-26 04:21:50 | Eddy, New Mexico, US | |
2965584 | 2965584 | 2021-12-24 | US | New Mexico | Eddy | 35015 | 12433 | 221 | 0 | 32.47167456 | -104.3053527 | 2021-12-25 04:21:37 | Eddy, New Mexico, US | |
3818616 | 3818616 | 2021-12-23 | US | New Mexico | Eddy | 35015 | 12433 | 221 | 0 | 32.47167456 | -104.3053527 | 2021-12-24 04:21:34 | Eddy, New Mexico, US | |
552962 | 552962 | 2021-12-08 | US | New Mexico | Chaves | 35005 | 14278 | 221 | 0 | 33.36406072 | -104.4665365 | 2021-12-09 04:22:49 | Chaves, New Mexico, US | |
406482 | 406482 | 2021-12-07 | US | New Mexico | Chaves | 35005 | 14203 | 221 | 0 | 33.36406072 | -104.4665365 | 2021-12-08 04:22:46 | Chaves, New Mexico, US | |
1387826 | 1387826 | 2021-09-13 | US | New Mexico | Lea | 35025 | 12161 | 221 | 0 | 32.79215361 | -103.4123733 | 2021-09-14 04:21:41 | Lea, New Mexico, US | |
1887195 | 1887195 | 2021-09-12 | US | New Mexico | Lea | 35025 | 12044 | 221 | 0 | 32.79215361 | -103.4123733 | 2021-09-13 04:21:15 | Lea, New Mexico, US | |
3808098 | 3808098 | 2021-09-11 | US | New Mexico | Lea | 35025 | 12044 | 221 | 0 | 32.79215361 | -103.4123733 | 2021-09-12 04:21:13 | Lea, New Mexico, US | |
3451038 | 3451038 | 2021-09-10 | US | New Mexico | Lea | 35025 | 12044 | 221 | 0 | 32.79215361 | -103.4123733 | 2021-09-11 04:21:30 | Lea, New Mexico, US | |
2977409 | 2977409 | 2020-12-09 | US | New Mexico | Dona Ana | 35013 | 14998 | 221 | 0 | 14777 | 32.35275771 | -106.8329387 | 2020-12-10 05:26:19 | Dona Ana, New Mexico, US |
2738602 | 2738602 | 2020-08-03 | US | New Mexico | McKinley | 35031 | 4004 | 221 | 0 | 3783 | 35.58007720000001 | -108.262245 | 2020-08-04 04:41:59 | McKinley, New Mexico, US |
2806354 | 2806354 | 2020-08-02 | US | New Mexico | McKinley | 35031 | 4002 | 221 | 0 | 3781 | 35.58007720000001 | -108.262245 | 2020-08-03 04:34:35 | McKinley, New Mexico, 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]);