ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,276 rows where county = "Columbia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
- Washington 793
- Georgia 787
- Wisconsin 786
- New York 785
- Florida 783
- Pennsylvania 783
- Arkansas 781
- Oregon 778
county 1
- Columbia · 6,276 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499699 | 2499699 | 2022-05-13 | Columbia | Arkansas | 5027 | 5438 | 95 |
2499909 | 2499909 | 2022-05-13 | Columbia | Florida | 12023 | 21193 | 402 |
2500001 | 2500001 | 2022-05-13 | Columbia | Georgia | 13073 | 36344 | 390 |
2501437 | 2501437 | 2022-05-13 | Columbia | New York | 36021 | 10772 | 141 |
2501815 | 2501815 | 2022-05-13 | Columbia | Oregon | 41009 | 7987 | 95 |
2501865 | 2501865 | 2022-05-13 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
2502649 | 2502649 | 2022-05-13 | Columbia | Washington | 53013 | 613 | 16 |
2502748 | 2502748 | 2022-05-13 | Columbia | Wisconsin | 55021 | 15821 | 128 |
2496441 | 2496441 | 2022-05-12 | Columbia | Arkansas | 5027 | 5436 | 95 |
2496651 | 2496651 | 2022-05-12 | Columbia | Florida | 12023 | 21193 | 402 |
2496743 | 2496743 | 2022-05-12 | Columbia | Georgia | 13073 | 36344 | 390 |
2498179 | 2498179 | 2022-05-12 | Columbia | New York | 36021 | 10772 | 140 |
2498557 | 2498557 | 2022-05-12 | Columbia | Oregon | 41009 | 7967 | 95 |
2498607 | 2498607 | 2022-05-12 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
2499391 | 2499391 | 2022-05-12 | Columbia | Washington | 53013 | 613 | 16 |
2499490 | 2499490 | 2022-05-12 | Columbia | Wisconsin | 55021 | 15792 | 128 |
2493183 | 2493183 | 2022-05-11 | Columbia | Arkansas | 5027 | 5430 | 95 |
2493393 | 2493393 | 2022-05-11 | Columbia | Florida | 12023 | 21193 | 402 |
2493485 | 2493485 | 2022-05-11 | Columbia | Georgia | 13073 | 36344 | 390 |
2494921 | 2494921 | 2022-05-11 | Columbia | New York | 36021 | 10734 | 140 |
2495299 | 2495299 | 2022-05-11 | Columbia | Oregon | 41009 | 7940 | 95 |
2495349 | 2495349 | 2022-05-11 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
2496133 | 2496133 | 2022-05-11 | Columbia | Washington | 53013 | 613 | 16 |
2496232 | 2496232 | 2022-05-11 | Columbia | Wisconsin | 55021 | 15753 | 127 |
2489925 | 2489925 | 2022-05-10 | Columbia | Arkansas | 5027 | 5430 | 95 |
2490135 | 2490135 | 2022-05-10 | Columbia | Florida | 12023 | 21193 | 402 |
2490227 | 2490227 | 2022-05-10 | Columbia | Georgia | 13073 | 36247 | 388 |
2491663 | 2491663 | 2022-05-10 | Columbia | New York | 36021 | 10698 | 140 |
2492041 | 2492041 | 2022-05-10 | Columbia | Oregon | 41009 | 7919 | 95 |
2492091 | 2492091 | 2022-05-10 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2492875 | 2492875 | 2022-05-10 | Columbia | Washington | 53013 | 612 | 16 |
2492974 | 2492974 | 2022-05-10 | Columbia | Wisconsin | 55021 | 15722 | 128 |
2486668 | 2486668 | 2022-05-09 | Columbia | Arkansas | 5027 | 5430 | 95 |
2486878 | 2486878 | 2022-05-09 | Columbia | Florida | 12023 | 21193 | 402 |
2486970 | 2486970 | 2022-05-09 | Columbia | Georgia | 13073 | 36247 | 388 |
2488405 | 2488405 | 2022-05-09 | Columbia | New York | 36021 | 10674 | 140 |
2488783 | 2488783 | 2022-05-09 | Columbia | Oregon | 41009 | 7897 | 95 |
2488833 | 2488833 | 2022-05-09 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2489617 | 2489617 | 2022-05-09 | Columbia | Washington | 53013 | 612 | 16 |
2489716 | 2489716 | 2022-05-09 | Columbia | Wisconsin | 55021 | 15704 | 128 |
2483410 | 2483410 | 2022-05-08 | Columbia | Arkansas | 5027 | 5430 | 95 |
2483620 | 2483620 | 2022-05-08 | Columbia | Florida | 12023 | 21193 | 402 |
2483712 | 2483712 | 2022-05-08 | Columbia | Georgia | 13073 | 36246 | 388 |
2485148 | 2485148 | 2022-05-08 | Columbia | New York | 36021 | 10656 | 140 |
2485526 | 2485526 | 2022-05-08 | Columbia | Oregon | 41009 | 7864 | 94 |
2485576 | 2485576 | 2022-05-08 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2486360 | 2486360 | 2022-05-08 | Columbia | Washington | 53013 | 610 | 16 |
2486459 | 2486459 | 2022-05-08 | Columbia | Wisconsin | 55021 | 15613 | 128 |
2480152 | 2480152 | 2022-05-07 | Columbia | Arkansas | 5027 | 5429 | 95 |
2480362 | 2480362 | 2022-05-07 | Columbia | Florida | 12023 | 21193 | 402 |
2480454 | 2480454 | 2022-05-07 | Columbia | Georgia | 13073 | 36246 | 388 |
2481890 | 2481890 | 2022-05-07 | Columbia | New York | 36021 | 10630 | 140 |
2482268 | 2482268 | 2022-05-07 | Columbia | Oregon | 41009 | 7864 | 94 |
2482318 | 2482318 | 2022-05-07 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2483102 | 2483102 | 2022-05-07 | Columbia | Washington | 53013 | 610 | 16 |
2483201 | 2483201 | 2022-05-07 | Columbia | Wisconsin | 55021 | 15613 | 128 |
2476894 | 2476894 | 2022-05-06 | Columbia | Arkansas | 5027 | 5428 | 95 |
2477104 | 2477104 | 2022-05-06 | Columbia | Florida | 12023 | 21193 | 402 |
2477196 | 2477196 | 2022-05-06 | Columbia | Georgia | 13073 | 36246 | 388 |
2478632 | 2478632 | 2022-05-06 | Columbia | New York | 36021 | 10607 | 140 |
2479010 | 2479010 | 2022-05-06 | Columbia | Oregon | 41009 | 7864 | 94 |
2479060 | 2479060 | 2022-05-06 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2479844 | 2479844 | 2022-05-06 | Columbia | Washington | 53013 | 610 | 16 |
2479943 | 2479943 | 2022-05-06 | Columbia | Wisconsin | 55021 | 15613 | 128 |
2473636 | 2473636 | 2022-05-05 | Columbia | Arkansas | 5027 | 5428 | 95 |
2473846 | 2473846 | 2022-05-05 | Columbia | Florida | 12023 | 21166 | 402 |
2473938 | 2473938 | 2022-05-05 | Columbia | Georgia | 13073 | 36246 | 388 |
2475374 | 2475374 | 2022-05-05 | Columbia | New York | 36021 | 10573 | 140 |
2475752 | 2475752 | 2022-05-05 | Columbia | Oregon | 41009 | 7859 | 94 |
2475802 | 2475802 | 2022-05-05 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2476586 | 2476586 | 2022-05-05 | Columbia | Washington | 53013 | 610 | 16 |
2476685 | 2476685 | 2022-05-05 | Columbia | Wisconsin | 55021 | 15582 | 128 |
2470379 | 2470379 | 2022-05-04 | Columbia | Arkansas | 5027 | 5427 | 95 |
2470589 | 2470589 | 2022-05-04 | Columbia | Florida | 12023 | 21166 | 402 |
2470681 | 2470681 | 2022-05-04 | Columbia | Georgia | 13073 | 36246 | 388 |
2472117 | 2472117 | 2022-05-04 | Columbia | New York | 36021 | 10543 | 140 |
2472495 | 2472495 | 2022-05-04 | Columbia | Oregon | 41009 | 7834 | 94 |
2472545 | 2472545 | 2022-05-04 | Columbia | Pennsylvania | 42037 | 15343 | 246 |
2473328 | 2473328 | 2022-05-04 | Columbia | Washington | 53013 | 610 | 16 |
2473427 | 2473427 | 2022-05-04 | Columbia | Wisconsin | 55021 | 15563 | 128 |
2467123 | 2467123 | 2022-05-03 | Columbia | Arkansas | 5027 | 5427 | 95 |
2467333 | 2467333 | 2022-05-03 | Columbia | Florida | 12023 | 21166 | 400 |
2467425 | 2467425 | 2022-05-03 | Columbia | Georgia | 13073 | 36177 | 386 |
2468861 | 2468861 | 2022-05-03 | Columbia | New York | 36021 | 10510 | 140 |
2469239 | 2469239 | 2022-05-03 | Columbia | Oregon | 41009 | 7804 | 94 |
2469289 | 2469289 | 2022-05-03 | Columbia | Pennsylvania | 42037 | 15321 | 246 |
2470072 | 2470072 | 2022-05-03 | Columbia | Washington | 53013 | 609 | 16 |
2470170 | 2470170 | 2022-05-03 | Columbia | Wisconsin | 55021 | 15544 | 127 |
2463868 | 2463868 | 2022-05-02 | Columbia | Arkansas | 5027 | 5427 | 95 |
2464078 | 2464078 | 2022-05-02 | Columbia | Florida | 12023 | 21166 | 400 |
2464170 | 2464170 | 2022-05-02 | Columbia | Georgia | 13073 | 36177 | 386 |
2465605 | 2465605 | 2022-05-02 | Columbia | New York | 36021 | 10493 | 140 |
2465983 | 2465983 | 2022-05-02 | Columbia | Oregon | 41009 | 7775 | 94 |
2466033 | 2466033 | 2022-05-02 | Columbia | Pennsylvania | 42037 | 15307 | 246 |
2466816 | 2466816 | 2022-05-02 | Columbia | Washington | 53013 | 609 | 16 |
2466914 | 2466914 | 2022-05-02 | Columbia | Wisconsin | 55021 | 15530 | 127 |
2460612 | 2460612 | 2022-05-01 | Columbia | Arkansas | 5027 | 5427 | 95 |
2460822 | 2460822 | 2022-05-01 | Columbia | Florida | 12023 | 21166 | 400 |
2460914 | 2460914 | 2022-05-01 | Columbia | Georgia | 13073 | 36176 | 386 |
2462350 | 2462350 | 2022-05-01 | Columbia | New York | 36021 | 10479 | 140 |
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);