ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where fips = "" and state = "Alaska" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26171 | 26171 | 2020-04-02 | Unknown | Alaska | 1 | 0 | |
40701 | 40701 | 2020-04-08 | Unknown | Alaska | 1 | 0 | |
190798 | 190798 | 2020-05-30 | Unknown | Alaska | 1 | 0 | |
193865 | 193865 | 2020-05-31 | Unknown | Alaska | 1 | 0 | |
196935 | 196935 | 2020-06-01 | Unknown | Alaska | 1 | 0 | |
200008 | 200008 | 2020-06-02 | Unknown | Alaska | 1 | 0 | |
203084 | 203084 | 2020-06-03 | Unknown | Alaska | 1 | 0 | |
206164 | 206164 | 2020-06-04 | Unknown | Alaska | 1 | 0 | |
221602 | 221602 | 2020-06-09 | Unknown | Alaska | 1 | 0 | |
227799 | 227799 | 2020-06-11 | Unknown | Alaska | 2 | 0 | |
234008 | 234008 | 2020-06-13 | Unknown | Alaska | 1 | 0 | |
237115 | 237115 | 2020-06-14 | Unknown | Alaska | 1 | 0 | |
240223 | 240223 | 2020-06-15 | Unknown | Alaska | 1 | 0 | |
243334 | 243334 | 2020-06-16 | Unknown | Alaska | 1 | 0 | |
246447 | 246447 | 2020-06-17 | Unknown | Alaska | 1 | 0 | |
249559 | 249559 | 2020-06-18 | Unknown | Alaska | 2 | 0 | |
252674 | 252674 | 2020-06-19 | Unknown | Alaska | 12 | 0 | |
255793 | 255793 | 2020-06-20 | Unknown | Alaska | 5 | 0 | |
258920 | 258920 | 2020-06-21 | Unknown | Alaska | 5 | 0 | |
262047 | 262047 | 2020-06-22 | Unknown | Alaska | 6 | 0 | |
268305 | 268305 | 2020-06-24 | Unknown | Alaska | 6 | 0 | |
271440 | 271440 | 2020-06-25 | Unknown | Alaska | 20 | 0 | |
274580 | 274580 | 2020-06-26 | Unknown | Alaska | 4 | 0 | |
277728 | 277728 | 2020-06-27 | Unknown | Alaska | 4 | 0 | |
290318 | 290318 | 2020-07-01 | Unknown | Alaska | 2 | 0 | |
293471 | 293471 | 2020-07-02 | Unknown | Alaska | 13 | 0 | |
296627 | 296627 | 2020-07-03 | Unknown | Alaska | 7 | 0 | |
299789 | 299789 | 2020-07-04 | Unknown | Alaska | 6 | 0 | |
302953 | 302953 | 2020-07-05 | Unknown | Alaska | 7 | 0 | |
306117 | 306117 | 2020-07-06 | Unknown | Alaska | 8 | 0 | |
312455 | 312455 | 2020-07-08 | Unknown | Alaska | 2 | 0 | |
315630 | 315630 | 2020-07-09 | Unknown | Alaska | 5 | 0 | |
318803 | 318803 | 2020-07-10 | Unknown | Alaska | 5 | 0 | |
321982 | 321982 | 2020-07-11 | Unknown | Alaska | 8 | 0 | |
325163 | 325163 | 2020-07-12 | Unknown | Alaska | 15 | 0 | |
328349 | 328349 | 2020-07-13 | Unknown | Alaska | 17 | 0 | |
331535 | 331535 | 2020-07-14 | Unknown | Alaska | 13 | 0 | |
334728 | 334728 | 2020-07-15 | Unknown | Alaska | 13 | 0 | |
337923 | 337923 | 2020-07-16 | Unknown | Alaska | 15 | 0 | |
341119 | 341119 | 2020-07-17 | Unknown | Alaska | 8 | 0 | |
344318 | 344318 | 2020-07-18 | Unknown | Alaska | 6 | 0 | |
347518 | 347518 | 2020-07-19 | Unknown | Alaska | 9 | 0 | |
350719 | 350719 | 2020-07-20 | Unknown | Alaska | 2 | 0 | |
353921 | 353921 | 2020-07-21 | Unknown | Alaska | 5 | 0 | |
357124 | 357124 | 2020-07-22 | Unknown | Alaska | 8 | 0 | |
360329 | 360329 | 2020-07-23 | Unknown | Alaska | 9 | 0 | |
363535 | 363535 | 2020-07-24 | Unknown | Alaska | 11 | 0 | |
366742 | 366742 | 2020-07-25 | Unknown | Alaska | 16 | 0 | |
369952 | 369952 | 2020-07-26 | Unknown | Alaska | 22 | 0 | |
373164 | 373164 | 2020-07-27 | Unknown | Alaska | 26 | 0 | |
376378 | 376378 | 2020-07-28 | Unknown | Alaska | 35 | 0 | |
379594 | 379594 | 2020-07-29 | Unknown | Alaska | 37 | 0 | |
382811 | 382811 | 2020-07-30 | Unknown | Alaska | 37 | 0 | |
386029 | 386029 | 2020-07-31 | Unknown | Alaska | 39 | 0 | |
389246 | 389246 | 2020-08-01 | Unknown | Alaska | 36 | 0 | |
392463 | 392463 | 2020-08-02 | Unknown | Alaska | 48 | 0 | |
395679 | 395679 | 2020-08-03 | Unknown | Alaska | 47 | 0 | |
398895 | 398895 | 2020-08-04 | Unknown | Alaska | 31 | 0 | |
402111 | 402111 | 2020-08-05 | Unknown | Alaska | 29 | 0 | |
405329 | 405329 | 2020-08-06 | Unknown | Alaska | 27 | 0 | |
408549 | 408549 | 2020-08-07 | Unknown | Alaska | 28 | 0 | |
411768 | 411768 | 2020-08-08 | Unknown | Alaska | 28 | 0 | |
414988 | 414988 | 2020-08-09 | Unknown | Alaska | 29 | 0 | |
418209 | 418209 | 2020-08-10 | Unknown | Alaska | 30 | 0 | |
421430 | 421430 | 2020-08-11 | Unknown | Alaska | 34 | 0 | |
424651 | 424651 | 2020-08-12 | Unknown | Alaska | 34 | 0 | |
427875 | 427875 | 2020-08-13 | Unknown | Alaska | 37 | 0 | |
431103 | 431103 | 2020-08-14 | Unknown | Alaska | 41 | 0 | |
434328 | 434328 | 2020-08-15 | Unknown | Alaska | 40 | 0 | |
437554 | 437554 | 2020-08-16 | Unknown | Alaska | 40 | 0 | |
440780 | 440780 | 2020-08-17 | Unknown | Alaska | 40 | 0 | |
444006 | 444006 | 2020-08-18 | Unknown | Alaska | 40 | 0 | |
447233 | 447233 | 2020-08-19 | Unknown | Alaska | 40 | 0 | |
450461 | 450461 | 2020-08-20 | Unknown | Alaska | 41 | 0 | |
453689 | 453689 | 2020-08-21 | Unknown | Alaska | 42 | 0 | |
456917 | 456917 | 2020-08-22 | Unknown | Alaska | 40 | 0 | |
460144 | 460144 | 2020-08-23 | Unknown | Alaska | 40 | 0 | |
463373 | 463373 | 2020-08-24 | Unknown | Alaska | 41 | 0 | |
466602 | 466602 | 2020-08-25 | Unknown | Alaska | 37 | 0 | |
469831 | 469831 | 2020-08-26 | Unknown | Alaska | 39 | 0 | |
473063 | 473063 | 2020-08-27 | Unknown | Alaska | 38 | 0 | |
476296 | 476296 | 2020-08-28 | Unknown | Alaska | 38 | 0 | |
479529 | 479529 | 2020-08-29 | Unknown | Alaska | 38 | 0 | |
482763 | 482763 | 2020-08-30 | Unknown | Alaska | 36 | 0 | |
485998 | 485998 | 2020-08-31 | Unknown | Alaska | 36 | 0 | |
489231 | 489231 | 2020-09-01 | Unknown | Alaska | 37 | 0 | |
492464 | 492464 | 2020-09-02 | Unknown | Alaska | 36 | 0 | |
495698 | 495698 | 2020-09-03 | Unknown | Alaska | 37 | 0 | |
498931 | 498931 | 2020-09-04 | Unknown | Alaska | 37 | 0 | |
502165 | 502165 | 2020-09-05 | Unknown | Alaska | 37 | 0 | |
505399 | 505399 | 2020-09-06 | Unknown | Alaska | 37 | 0 | |
508631 | 508631 | 2020-09-07 | Unknown | Alaska | 37 | 0 | |
511864 | 511864 | 2020-09-08 | Unknown | Alaska | 37 | 0 | |
515097 | 515097 | 2020-09-09 | Unknown | Alaska | 37 | 0 | |
518332 | 518332 | 2020-09-10 | Unknown | Alaska | 38 | 0 | |
521569 | 521569 | 2020-09-11 | Unknown | Alaska | 39 | 0 | |
524805 | 524805 | 2020-09-12 | Unknown | Alaska | 41 | 0 | |
528041 | 528041 | 2020-09-13 | Unknown | Alaska | 41 | 0 | |
531278 | 531278 | 2020-09-14 | Unknown | Alaska | 43 | 0 | |
534513 | 534513 | 2020-09-15 | Unknown | Alaska | 43 | 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);