ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Crawford" and state = "Pennsylvania" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
301918 | 301918 | 2020-07-04 | Crawford | Pennsylvania | 42039 | 62 | 0 |
305081 | 305081 | 2020-07-05 | Crawford | Pennsylvania | 42039 | 66 | 0 |
308248 | 308248 | 2020-07-06 | Crawford | Pennsylvania | 42039 | 70 | 0 |
311417 | 311417 | 2020-07-07 | Crawford | Pennsylvania | 42039 | 72 | 0 |
314589 | 314589 | 2020-07-08 | Crawford | Pennsylvania | 42039 | 74 | 1 |
317762 | 317762 | 2020-07-09 | Crawford | Pennsylvania | 42039 | 76 | 1 |
320940 | 320940 | 2020-07-10 | Crawford | Pennsylvania | 42039 | 77 | 1 |
324120 | 324120 | 2020-07-11 | Crawford | Pennsylvania | 42039 | 77 | 1 |
327305 | 327305 | 2020-07-12 | Crawford | Pennsylvania | 42039 | 77 | 1 |
330491 | 330491 | 2020-07-13 | Crawford | Pennsylvania | 42039 | 78 | 1 |
333683 | 333683 | 2020-07-14 | Crawford | Pennsylvania | 42039 | 80 | 1 |
336877 | 336877 | 2020-07-15 | Crawford | Pennsylvania | 42039 | 101 | 1 |
340074 | 340074 | 2020-07-16 | Crawford | Pennsylvania | 42039 | 104 | 1 |
343272 | 343272 | 2020-07-17 | Crawford | Pennsylvania | 42039 | 105 | 1 |
346472 | 346472 | 2020-07-18 | Crawford | Pennsylvania | 42039 | 107 | 1 |
349672 | 349672 | 2020-07-19 | Crawford | Pennsylvania | 42039 | 107 | 1 |
352875 | 352875 | 2020-07-20 | Crawford | Pennsylvania | 42039 | 109 | 1 |
356078 | 356078 | 2020-07-21 | Crawford | Pennsylvania | 42039 | 112 | 1 |
359282 | 359282 | 2020-07-22 | Crawford | Pennsylvania | 42039 | 114 | 1 |
362488 | 362488 | 2020-07-23 | Crawford | Pennsylvania | 42039 | 114 | 1 |
365694 | 365694 | 2020-07-24 | Crawford | Pennsylvania | 42039 | 117 | 1 |
368903 | 368903 | 2020-07-25 | Crawford | Pennsylvania | 42039 | 118 | 1 |
372115 | 372115 | 2020-07-26 | Crawford | Pennsylvania | 42039 | 118 | 1 |
375328 | 375328 | 2020-07-27 | Crawford | Pennsylvania | 42039 | 118 | 1 |
378544 | 378544 | 2020-07-28 | Crawford | Pennsylvania | 42039 | 118 | 1 |
381761 | 381761 | 2020-07-29 | Crawford | Pennsylvania | 42039 | 120 | 1 |
384979 | 384979 | 2020-07-30 | Crawford | Pennsylvania | 42039 | 122 | 1 |
388196 | 388196 | 2020-07-31 | Crawford | Pennsylvania | 42039 | 124 | 1 |
391413 | 391413 | 2020-08-01 | Crawford | Pennsylvania | 42039 | 126 | 1 |
394629 | 394629 | 2020-08-02 | Crawford | Pennsylvania | 42039 | 127 | 1 |
397846 | 397846 | 2020-08-03 | Crawford | Pennsylvania | 42039 | 132 | 1 |
401061 | 401061 | 2020-08-04 | Crawford | Pennsylvania | 42039 | 133 | 1 |
404279 | 404279 | 2020-08-05 | Crawford | Pennsylvania | 42039 | 136 | 1 |
407498 | 407498 | 2020-08-06 | Crawford | Pennsylvania | 42039 | 138 | 1 |
410718 | 410718 | 2020-08-07 | Crawford | Pennsylvania | 42039 | 139 | 1 |
413938 | 413938 | 2020-08-08 | Crawford | Pennsylvania | 42039 | 141 | 1 |
417159 | 417159 | 2020-08-09 | Crawford | Pennsylvania | 42039 | 144 | 1 |
420379 | 420379 | 2020-08-10 | Crawford | Pennsylvania | 42039 | 154 | 1 |
423602 | 423602 | 2020-08-11 | Crawford | Pennsylvania | 42039 | 158 | 1 |
426825 | 426825 | 2020-08-12 | Crawford | Pennsylvania | 42039 | 162 | 1 |
430050 | 430050 | 2020-08-13 | Crawford | Pennsylvania | 42039 | 161 | 1 |
433276 | 433276 | 2020-08-14 | Crawford | Pennsylvania | 42039 | 165 | 1 |
436503 | 436503 | 2020-08-15 | Crawford | Pennsylvania | 42039 | 166 | 1 |
439728 | 439728 | 2020-08-16 | Crawford | Pennsylvania | 42039 | 168 | 1 |
442955 | 442955 | 2020-08-17 | Crawford | Pennsylvania | 42039 | 169 | 1 |
446181 | 446181 | 2020-08-18 | Crawford | Pennsylvania | 42039 | 172 | 1 |
449409 | 449409 | 2020-08-19 | Crawford | Pennsylvania | 42039 | 177 | 1 |
452637 | 452637 | 2020-08-20 | Crawford | Pennsylvania | 42039 | 178 | 2 |
455865 | 455865 | 2020-08-21 | Crawford | Pennsylvania | 42039 | 181 | 2 |
459093 | 459093 | 2020-08-22 | Crawford | Pennsylvania | 42039 | 184 | 2 |
462321 | 462321 | 2020-08-23 | Crawford | Pennsylvania | 42039 | 186 | 2 |
465550 | 465550 | 2020-08-24 | Crawford | Pennsylvania | 42039 | 190 | 2 |
468778 | 468778 | 2020-08-25 | Crawford | Pennsylvania | 42039 | 192 | 2 |
472010 | 472010 | 2020-08-26 | Crawford | Pennsylvania | 42039 | 193 | 2 |
475244 | 475244 | 2020-08-27 | Crawford | Pennsylvania | 42039 | 201 | 2 |
478477 | 478477 | 2020-08-28 | Crawford | Pennsylvania | 42039 | 203 | 2 |
481711 | 481711 | 2020-08-29 | Crawford | Pennsylvania | 42039 | 209 | 2 |
484946 | 484946 | 2020-08-30 | Crawford | Pennsylvania | 42039 | 214 | 2 |
488179 | 488179 | 2020-08-31 | Crawford | Pennsylvania | 42039 | 214 | 2 |
491412 | 491412 | 2020-09-01 | Crawford | Pennsylvania | 42039 | 217 | 2 |
494646 | 494646 | 2020-09-02 | Crawford | Pennsylvania | 42039 | 218 | 2 |
497879 | 497879 | 2020-09-03 | Crawford | Pennsylvania | 42039 | 220 | 2 |
501113 | 501113 | 2020-09-04 | Crawford | Pennsylvania | 42039 | 222 | 2 |
504347 | 504347 | 2020-09-05 | Crawford | Pennsylvania | 42039 | 222 | 2 |
507579 | 507579 | 2020-09-06 | Crawford | Pennsylvania | 42039 | 235 | 2 |
510812 | 510812 | 2020-09-07 | Crawford | Pennsylvania | 42039 | 236 | 2 |
514045 | 514045 | 2020-09-08 | Crawford | Pennsylvania | 42039 | 237 | 2 |
517280 | 517280 | 2020-09-09 | Crawford | Pennsylvania | 42039 | 237 | 2 |
520516 | 520516 | 2020-09-10 | Crawford | Pennsylvania | 42039 | 241 | 2 |
523752 | 523752 | 2020-09-11 | Crawford | Pennsylvania | 42039 | 245 | 2 |
526988 | 526988 | 2020-09-12 | Crawford | Pennsylvania | 42039 | 245 | 2 |
530225 | 530225 | 2020-09-13 | Crawford | Pennsylvania | 42039 | 245 | 2 |
533460 | 533460 | 2020-09-14 | Crawford | Pennsylvania | 42039 | 254 | 3 |
536696 | 536696 | 2020-09-15 | Crawford | Pennsylvania | 42039 | 257 | 3 |
539933 | 539933 | 2020-09-16 | Crawford | Pennsylvania | 42039 | 263 | 3 |
543169 | 543169 | 2020-09-17 | Crawford | Pennsylvania | 42039 | 283 | 3 |
546406 | 546406 | 2020-09-18 | Crawford | Pennsylvania | 42039 | 287 | 3 |
549645 | 549645 | 2020-09-19 | Crawford | Pennsylvania | 42039 | 288 | 3 |
552884 | 552884 | 2020-09-20 | Crawford | Pennsylvania | 42039 | 291 | 3 |
556121 | 556121 | 2020-09-21 | Crawford | Pennsylvania | 42039 | 290 | 3 |
559358 | 559358 | 2020-09-22 | Crawford | Pennsylvania | 42039 | 293 | 3 |
562595 | 562595 | 2020-09-23 | Crawford | Pennsylvania | 42039 | 298 | 3 |
565836 | 565836 | 2020-09-24 | Crawford | Pennsylvania | 42039 | 297 | 3 |
569077 | 569077 | 2020-09-25 | Crawford | Pennsylvania | 42039 | 303 | 3 |
572319 | 572319 | 2020-09-26 | Crawford | Pennsylvania | 42039 | 304 | 3 |
575563 | 575563 | 2020-09-27 | Crawford | Pennsylvania | 42039 | 305 | 3 |
578804 | 578804 | 2020-09-28 | Crawford | Pennsylvania | 42039 | 308 | 3 |
582044 | 582044 | 2020-09-29 | Crawford | Pennsylvania | 42039 | 311 | 3 |
585284 | 585284 | 2020-09-30 | Crawford | Pennsylvania | 42039 | 316 | 3 |
588524 | 588524 | 2020-10-01 | Crawford | Pennsylvania | 42039 | 317 | 3 |
591765 | 591765 | 2020-10-02 | Crawford | Pennsylvania | 42039 | 321 | 3 |
595006 | 595006 | 2020-10-03 | Crawford | Pennsylvania | 42039 | 321 | 3 |
598249 | 598249 | 2020-10-04 | Crawford | Pennsylvania | 42039 | 324 | 3 |
601492 | 601492 | 2020-10-05 | Crawford | Pennsylvania | 42039 | 330 | 3 |
604734 | 604734 | 2020-10-06 | Crawford | Pennsylvania | 42039 | 331 | 3 |
607977 | 607977 | 2020-10-07 | Crawford | Pennsylvania | 42039 | 332 | 3 |
611219 | 611219 | 2020-10-08 | Crawford | Pennsylvania | 42039 | 334 | 3 |
614460 | 614460 | 2020-10-09 | Crawford | Pennsylvania | 42039 | 336 | 3 |
617702 | 617702 | 2020-10-10 | Crawford | Pennsylvania | 42039 | 342 | 3 |
620945 | 620945 | 2020-10-11 | Crawford | Pennsylvania | 42039 | 345 | 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);