ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Unknown" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382811 | 382811 | 2020-07-30 | Unknown | Alaska | 37 | 0 | |
379594 | 379594 | 2020-07-29 | Unknown | Alaska | 37 | 0 | |
376378 | 376378 | 2020-07-28 | Unknown | Alaska | 35 | 0 | |
373164 | 373164 | 2020-07-27 | Unknown | Alaska | 26 | 0 | |
369952 | 369952 | 2020-07-26 | Unknown | Alaska | 22 | 0 | |
366742 | 366742 | 2020-07-25 | Unknown | Alaska | 16 | 0 | |
363535 | 363535 | 2020-07-24 | Unknown | Alaska | 11 | 0 | |
360329 | 360329 | 2020-07-23 | Unknown | Alaska | 9 | 0 | |
357124 | 357124 | 2020-07-22 | Unknown | Alaska | 8 | 0 | |
353921 | 353921 | 2020-07-21 | Unknown | Alaska | 5 | 0 | |
350719 | 350719 | 2020-07-20 | Unknown | Alaska | 2 | 0 | |
347518 | 347518 | 2020-07-19 | Unknown | Alaska | 9 | 0 | |
344318 | 344318 | 2020-07-18 | Unknown | Alaska | 6 | 0 | |
341119 | 341119 | 2020-07-17 | Unknown | Alaska | 8 | 0 | |
337923 | 337923 | 2020-07-16 | Unknown | Alaska | 15 | 0 | |
334728 | 334728 | 2020-07-15 | Unknown | Alaska | 13 | 0 | |
331535 | 331535 | 2020-07-14 | Unknown | Alaska | 13 | 0 | |
328349 | 328349 | 2020-07-13 | Unknown | Alaska | 17 | 0 | |
325163 | 325163 | 2020-07-12 | Unknown | Alaska | 15 | 0 | |
321982 | 321982 | 2020-07-11 | Unknown | Alaska | 8 | 0 | |
318803 | 318803 | 2020-07-10 | Unknown | Alaska | 5 | 0 | |
315630 | 315630 | 2020-07-09 | Unknown | Alaska | 5 | 0 | |
312455 | 312455 | 2020-07-08 | Unknown | Alaska | 2 | 0 | |
306117 | 306117 | 2020-07-06 | Unknown | Alaska | 8 | 0 | |
302953 | 302953 | 2020-07-05 | Unknown | Alaska | 7 | 0 | |
299789 | 299789 | 2020-07-04 | Unknown | Alaska | 6 | 0 | |
296627 | 296627 | 2020-07-03 | Unknown | Alaska | 7 | 0 | |
293471 | 293471 | 2020-07-02 | Unknown | Alaska | 13 | 0 | |
290318 | 290318 | 2020-07-01 | Unknown | Alaska | 2 | 0 | |
277728 | 277728 | 2020-06-27 | Unknown | Alaska | 4 | 0 | |
274580 | 274580 | 2020-06-26 | Unknown | Alaska | 4 | 0 | |
271440 | 271440 | 2020-06-25 | Unknown | Alaska | 20 | 0 | |
268305 | 268305 | 2020-06-24 | Unknown | Alaska | 6 | 0 | |
262047 | 262047 | 2020-06-22 | Unknown | Alaska | 6 | 0 | |
258920 | 258920 | 2020-06-21 | Unknown | Alaska | 5 | 0 | |
255793 | 255793 | 2020-06-20 | Unknown | Alaska | 5 | 0 | |
252674 | 252674 | 2020-06-19 | Unknown | Alaska | 12 | 0 | |
249559 | 249559 | 2020-06-18 | Unknown | Alaska | 2 | 0 | |
246447 | 246447 | 2020-06-17 | Unknown | Alaska | 1 | 0 | |
243334 | 243334 | 2020-06-16 | Unknown | Alaska | 1 | 0 | |
240223 | 240223 | 2020-06-15 | Unknown | Alaska | 1 | 0 | |
237115 | 237115 | 2020-06-14 | Unknown | Alaska | 1 | 0 | |
234008 | 234008 | 2020-06-13 | Unknown | Alaska | 1 | 0 | |
227799 | 227799 | 2020-06-11 | Unknown | Alaska | 2 | 0 | |
221602 | 221602 | 2020-06-09 | Unknown | Alaska | 1 | 0 | |
206164 | 206164 | 2020-06-04 | Unknown | Alaska | 1 | 0 | |
203084 | 203084 | 2020-06-03 | Unknown | Alaska | 1 | 0 | |
200008 | 200008 | 2020-06-02 | Unknown | Alaska | 1 | 0 | |
196935 | 196935 | 2020-06-01 | Unknown | Alaska | 1 | 0 | |
193865 | 193865 | 2020-05-31 | Unknown | Alaska | 1 | 0 | |
190798 | 190798 | 2020-05-30 | Unknown | Alaska | 1 | 0 | |
40701 | 40701 | 2020-04-08 | Unknown | Alaska | 1 | 0 | |
26171 | 26171 | 2020-04-02 | Unknown | Alaska | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);