ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Grant" and fips = 53025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537481 | 537481 | 2020-09-15 | Grant | Washington | 53025 | 2773 | 17 |
534245 | 534245 | 2020-09-14 | Grant | Washington | 53025 | 2758 | 17 |
531010 | 531010 | 2020-09-13 | Grant | Washington | 53025 | 2661 | 16 |
527773 | 527773 | 2020-09-12 | Grant | Washington | 53025 | 2661 | 16 |
524537 | 524537 | 2020-09-11 | Grant | Washington | 53025 | 2661 | 16 |
521301 | 521301 | 2020-09-10 | Grant | Washington | 53025 | 2643 | 16 |
518064 | 518064 | 2020-09-09 | Grant | Washington | 53025 | 2601 | 16 |
514829 | 514829 | 2020-09-08 | Grant | Washington | 53025 | 2587 | 16 |
511596 | 511596 | 2020-09-07 | Grant | Washington | 53025 | 2497 | 16 |
508363 | 508363 | 2020-09-06 | Grant | Washington | 53025 | 2497 | 16 |
505131 | 505131 | 2020-09-05 | Grant | Washington | 53025 | 2497 | 16 |
501897 | 501897 | 2020-09-04 | Grant | Washington | 53025 | 2497 | 16 |
498663 | 498663 | 2020-09-03 | Grant | Washington | 53025 | 2467 | 16 |
495430 | 495430 | 2020-09-02 | Grant | Washington | 53025 | 2427 | 14 |
492196 | 492196 | 2020-09-01 | Grant | Washington | 53025 | 2371 | 14 |
488963 | 488963 | 2020-08-31 | Grant | Washington | 53025 | 2371 | 14 |
485730 | 485730 | 2020-08-30 | Grant | Washington | 53025 | 2310 | 14 |
482495 | 482495 | 2020-08-29 | Grant | Washington | 53025 | 2310 | 14 |
479261 | 479261 | 2020-08-28 | Grant | Washington | 53025 | 2310 | 14 |
476028 | 476028 | 2020-08-27 | Grant | Washington | 53025 | 2234 | 13 |
472795 | 472795 | 2020-08-26 | Grant | Washington | 53025 | 2215 | 13 |
469563 | 469563 | 2020-08-25 | Grant | Washington | 53025 | 2179 | 14 |
466334 | 466334 | 2020-08-24 | Grant | Washington | 53025 | 2170 | 14 |
463105 | 463105 | 2020-08-23 | Grant | Washington | 53025 | 2098 | 14 |
459876 | 459876 | 2020-08-22 | Grant | Washington | 53025 | 2098 | 14 |
456649 | 456649 | 2020-08-21 | Grant | Washington | 53025 | 2098 | 14 |
453421 | 453421 | 2020-08-20 | Grant | Washington | 53025 | 2021 | 14 |
450193 | 450193 | 2020-08-19 | Grant | Washington | 53025 | 1993 | 14 |
446965 | 446965 | 2020-08-18 | Grant | Washington | 53025 | 1950 | 13 |
443738 | 443738 | 2020-08-17 | Grant | Washington | 53025 | 1920 | 13 |
440512 | 440512 | 2020-08-16 | Grant | Washington | 53025 | 1820 | 12 |
437286 | 437286 | 2020-08-15 | Grant | Washington | 53025 | 1773 | 12 |
434060 | 434060 | 2020-08-14 | Grant | Washington | 53025 | 1773 | 12 |
430835 | 430835 | 2020-08-13 | Grant | Washington | 53025 | 1721 | 12 |
427607 | 427607 | 2020-08-12 | Grant | Washington | 53025 | 1632 | 12 |
424383 | 424383 | 2020-08-11 | Grant | Washington | 53025 | 1632 | 12 |
421162 | 421162 | 2020-08-10 | Grant | Washington | 53025 | 1614 | 12 |
417941 | 417941 | 2020-08-09 | Grant | Washington | 53025 | 1505 | 12 |
414720 | 414720 | 2020-08-08 | Grant | Washington | 53025 | 1505 | 12 |
411500 | 411500 | 2020-08-07 | Grant | Washington | 53025 | 1505 | 12 |
408281 | 408281 | 2020-08-06 | Grant | Washington | 53025 | 1469 | 11 |
405061 | 405061 | 2020-08-05 | Grant | Washington | 53025 | 1411 | 11 |
401843 | 401843 | 2020-08-04 | Grant | Washington | 53025 | 1382 | 11 |
398627 | 398627 | 2020-08-03 | Grant | Washington | 53025 | 1376 | 11 |
395411 | 395411 | 2020-08-02 | Grant | Washington | 53025 | 1309 | 12 |
392195 | 392195 | 2020-08-01 | Grant | Washington | 53025 | 1281 | 12 |
388978 | 388978 | 2020-07-31 | Grant | Washington | 53025 | 1281 | 11 |
385761 | 385761 | 2020-07-30 | Grant | Washington | 53025 | 1256 | 11 |
382543 | 382543 | 2020-07-29 | Grant | Washington | 53025 | 1234 | 11 |
379326 | 379326 | 2020-07-28 | Grant | Washington | 53025 | 1210 | 11 |
376110 | 376110 | 2020-07-27 | Grant | Washington | 53025 | 1178 | 10 |
372896 | 372896 | 2020-07-26 | Grant | Washington | 53025 | 1128 | 10 |
369684 | 369684 | 2020-07-25 | Grant | Washington | 53025 | 1111 | 9 |
366475 | 366475 | 2020-07-24 | Grant | Washington | 53025 | 1111 | 8 |
363269 | 363269 | 2020-07-23 | Grant | Washington | 53025 | 1078 | 8 |
360063 | 360063 | 2020-07-22 | Grant | Washington | 53025 | 1054 | 7 |
356858 | 356858 | 2020-07-21 | Grant | Washington | 53025 | 1043 | 7 |
353655 | 353655 | 2020-07-20 | Grant | Washington | 53025 | 1023 | 7 |
350453 | 350453 | 2020-07-19 | Grant | Washington | 53025 | 964 | 7 |
347252 | 347252 | 2020-07-18 | Grant | Washington | 53025 | 964 | 7 |
344052 | 344052 | 2020-07-17 | Grant | Washington | 53025 | 964 | 7 |
340853 | 340853 | 2020-07-16 | Grant | Washington | 53025 | 934 | 7 |
337657 | 337657 | 2020-07-15 | Grant | Washington | 53025 | 908 | 7 |
334462 | 334462 | 2020-07-14 | Grant | Washington | 53025 | 895 | 7 |
331269 | 331269 | 2020-07-13 | Grant | Washington | 53025 | 891 | 7 |
328083 | 328083 | 2020-07-12 | Grant | Washington | 53025 | 802 | 7 |
324897 | 324897 | 2020-07-11 | Grant | Washington | 53025 | 802 | 7 |
321716 | 321716 | 2020-07-10 | Grant | Washington | 53025 | 802 | 7 |
318537 | 318537 | 2020-07-09 | Grant | Washington | 53025 | 788 | 7 |
315364 | 315364 | 2020-07-08 | Grant | Washington | 53025 | 762 | 5 |
312189 | 312189 | 2020-07-07 | Grant | Washington | 53025 | 742 | 5 |
309020 | 309020 | 2020-07-06 | Grant | Washington | 53025 | 724 | 5 |
305852 | 305852 | 2020-07-05 | Grant | Washington | 53025 | 646 | 5 |
302688 | 302688 | 2020-07-04 | Grant | Washington | 53025 | 646 | 5 |
299524 | 299524 | 2020-07-03 | Grant | Washington | 53025 | 646 | 5 |
296362 | 296362 | 2020-07-02 | Grant | Washington | 53025 | 634 | 5 |
293207 | 293207 | 2020-07-01 | Grant | Washington | 53025 | 621 | 5 |
290054 | 290054 | 2020-06-30 | Grant | Washington | 53025 | 611 | 5 |
286904 | 286904 | 2020-06-29 | Grant | Washington | 53025 | 610 | 5 |
283758 | 283758 | 2020-06-28 | Grant | Washington | 53025 | 577 | 5 |
280612 | 280612 | 2020-06-27 | Grant | Washington | 53025 | 577 | 5 |
277464 | 277464 | 2020-06-26 | Grant | Washington | 53025 | 564 | 5 |
274316 | 274316 | 2020-06-25 | Grant | Washington | 53025 | 513 | 5 |
271176 | 271176 | 2020-06-24 | Grant | Washington | 53025 | 478 | 5 |
268042 | 268042 | 2020-06-23 | Grant | Washington | 53025 | 470 | 5 |
264913 | 264913 | 2020-06-22 | Grant | Washington | 53025 | 470 | 4 |
261784 | 261784 | 2020-06-21 | Grant | Washington | 53025 | 404 | 4 |
258657 | 258657 | 2020-06-20 | Grant | Washington | 53025 | 404 | 4 |
255530 | 255530 | 2020-06-19 | Grant | Washington | 53025 | 404 | 4 |
252411 | 252411 | 2020-06-18 | Grant | Washington | 53025 | 390 | 4 |
249296 | 249296 | 2020-06-17 | Grant | Washington | 53025 | 390 | 4 |
246184 | 246184 | 2020-06-16 | Grant | Washington | 53025 | 370 | 4 |
243071 | 243071 | 2020-06-15 | Grant | Washington | 53025 | 370 | 4 |
239960 | 239960 | 2020-06-14 | Grant | Washington | 53025 | 321 | 4 |
236852 | 236852 | 2020-06-13 | Grant | Washington | 53025 | 321 | 4 |
233745 | 233745 | 2020-06-12 | Grant | Washington | 53025 | 321 | 4 |
230640 | 230640 | 2020-06-11 | Grant | Washington | 53025 | 303 | 3 |
227536 | 227536 | 2020-06-10 | Grant | Washington | 53025 | 298 | 3 |
224436 | 224436 | 2020-06-09 | Grant | Washington | 53025 | 288 | 3 |
221340 | 221340 | 2020-06-08 | Grant | Washington | 53025 | 283 | 3 |
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);