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)
state 8
- Washington 781
- Georgia 774
- Wisconsin 774
- New York 772
- Pennsylvania 771
- Florida 770
- Arkansas 768
- Oregon 766
county 1
- Columbia · 6,176 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462728 | 2462728 | 2022-05-01 | Columbia | Oregon | 41009 | 7745 | 93 |
2462778 | 2462778 | 2022-05-01 | Columbia | Pennsylvania | 42037 | 15290 | 246 |
2463561 | 2463561 | 2022-05-01 | Columbia | Washington | 53013 | 609 | 16 |
2463659 | 2463659 | 2022-05-01 | Columbia | Wisconsin | 55021 | 15491 | 127 |
2457356 | 2457356 | 2022-04-30 | Columbia | Arkansas | 5027 | 5427 | 95 |
2457566 | 2457566 | 2022-04-30 | Columbia | Florida | 12023 | 21166 | 400 |
2457658 | 2457658 | 2022-04-30 | Columbia | Georgia | 13073 | 36176 | 386 |
2459094 | 2459094 | 2022-04-30 | Columbia | New York | 36021 | 10459 | 140 |
2459472 | 2459472 | 2022-04-30 | Columbia | Oregon | 41009 | 7745 | 93 |
2459522 | 2459522 | 2022-04-30 | Columbia | Pennsylvania | 42037 | 15279 | 246 |
2460305 | 2460305 | 2022-04-30 | Columbia | Washington | 53013 | 609 | 16 |
2460403 | 2460403 | 2022-04-30 | Columbia | Wisconsin | 55021 | 15491 | 127 |
2454100 | 2454100 | 2022-04-29 | Columbia | Arkansas | 5027 | 5426 | 95 |
2454310 | 2454310 | 2022-04-29 | Columbia | Florida | 12023 | 21166 | 400 |
2454402 | 2454402 | 2022-04-29 | Columbia | Georgia | 13073 | 36176 | 386 |
2455838 | 2455838 | 2022-04-29 | Columbia | New York | 36021 | 10446 | 140 |
2456216 | 2456216 | 2022-04-29 | Columbia | Oregon | 41009 | 7745 | 93 |
2456266 | 2456266 | 2022-04-29 | Columbia | Pennsylvania | 42037 | 15266 | 246 |
2457049 | 2457049 | 2022-04-29 | Columbia | Washington | 53013 | 609 | 16 |
2457147 | 2457147 | 2022-04-29 | Columbia | Wisconsin | 55021 | 15491 | 127 |
2450844 | 2450844 | 2022-04-28 | Columbia | Arkansas | 5027 | 5426 | 95 |
2451054 | 2451054 | 2022-04-28 | Columbia | Florida | 12023 | 21166 | 400 |
2451146 | 2451146 | 2022-04-28 | Columbia | Georgia | 13073 | 36176 | 386 |
2452582 | 2452582 | 2022-04-28 | Columbia | New York | 36021 | 10381 | 140 |
2452960 | 2452960 | 2022-04-28 | Columbia | Oregon | 41009 | 7730 | 93 |
2453010 | 2453010 | 2022-04-28 | Columbia | Pennsylvania | 42037 | 15244 | 246 |
2453793 | 2453793 | 2022-04-28 | Columbia | Washington | 53013 | 608 | 16 |
2453891 | 2453891 | 2022-04-28 | Columbia | Wisconsin | 55021 | 15458 | 127 |
2447588 | 2447588 | 2022-04-27 | Columbia | Arkansas | 5027 | 5425 | 94 |
2447798 | 2447798 | 2022-04-27 | Columbia | Florida | 12023 | 21166 | 400 |
2447890 | 2447890 | 2022-04-27 | Columbia | Georgia | 13073 | 36176 | 386 |
2449326 | 2449326 | 2022-04-27 | Columbia | New York | 36021 | 10356 | 140 |
2449704 | 2449704 | 2022-04-27 | Columbia | Oregon | 41009 | 7714 | 93 |
2449754 | 2449754 | 2022-04-27 | Columbia | Pennsylvania | 42037 | 15232 | 245 |
2450537 | 2450537 | 2022-04-27 | Columbia | Washington | 53013 | 608 | 16 |
2450635 | 2450635 | 2022-04-27 | Columbia | Wisconsin | 55021 | 15435 | 127 |
2444332 | 2444332 | 2022-04-26 | Columbia | Arkansas | 5027 | 5425 | 94 |
2444542 | 2444542 | 2022-04-26 | Columbia | Florida | 12023 | 21166 | 397 |
2444634 | 2444634 | 2022-04-26 | Columbia | Georgia | 13073 | 36012 | 384 |
2446069 | 2446069 | 2022-04-26 | Columbia | New York | 36021 | 10343 | 140 |
2446447 | 2446447 | 2022-04-26 | Columbia | Oregon | 41009 | 7697 | 93 |
2446497 | 2446497 | 2022-04-26 | Columbia | Pennsylvania | 42037 | 15219 | 245 |
2447281 | 2447281 | 2022-04-26 | Columbia | Washington | 53013 | 608 | 16 |
2447379 | 2447379 | 2022-04-26 | Columbia | Wisconsin | 55021 | 15410 | 127 |
2441076 | 2441076 | 2022-04-25 | Columbia | Arkansas | 5027 | 5424 | 94 |
2441286 | 2441286 | 2022-04-25 | Columbia | Florida | 12023 | 21166 | 397 |
2441378 | 2441378 | 2022-04-25 | Columbia | Georgia | 13073 | 36012 | 384 |
2442814 | 2442814 | 2022-04-25 | Columbia | New York | 36021 | 10330 | 140 |
2443192 | 2443192 | 2022-04-25 | Columbia | Oregon | 41009 | 7689 | 93 |
2443242 | 2443242 | 2022-04-25 | Columbia | Pennsylvania | 42037 | 15209 | 245 |
2444025 | 2444025 | 2022-04-25 | Columbia | Washington | 53013 | 608 | 16 |
2444123 | 2444123 | 2022-04-25 | Columbia | Wisconsin | 55021 | 15387 | 127 |
2437820 | 2437820 | 2022-04-24 | Columbia | Arkansas | 5027 | 5424 | 94 |
2438030 | 2438030 | 2022-04-24 | Columbia | Florida | 12023 | 21166 | 397 |
2438122 | 2438122 | 2022-04-24 | Columbia | Georgia | 13073 | 36010 | 384 |
2439558 | 2439558 | 2022-04-24 | Columbia | New York | 36021 | 10317 | 140 |
2439936 | 2439936 | 2022-04-24 | Columbia | Oregon | 41009 | 7667 | 93 |
2439986 | 2439986 | 2022-04-24 | Columbia | Pennsylvania | 42037 | 15202 | 245 |
2440769 | 2440769 | 2022-04-24 | Columbia | Washington | 53013 | 608 | 16 |
2440867 | 2440867 | 2022-04-24 | Columbia | Wisconsin | 55021 | 15349 | 127 |
2434564 | 2434564 | 2022-04-23 | Columbia | Arkansas | 5027 | 5424 | 94 |
2434774 | 2434774 | 2022-04-23 | Columbia | Florida | 12023 | 21166 | 397 |
2434866 | 2434866 | 2022-04-23 | Columbia | Georgia | 13073 | 36010 | 384 |
2436302 | 2436302 | 2022-04-23 | Columbia | New York | 36021 | 10299 | 140 |
2436680 | 2436680 | 2022-04-23 | Columbia | Oregon | 41009 | 7667 | 93 |
2436730 | 2436730 | 2022-04-23 | Columbia | Pennsylvania | 42037 | 15196 | 245 |
2437513 | 2437513 | 2022-04-23 | Columbia | Washington | 53013 | 608 | 16 |
2437611 | 2437611 | 2022-04-23 | Columbia | Wisconsin | 55021 | 15349 | 127 |
2431308 | 2431308 | 2022-04-22 | Columbia | Arkansas | 5027 | 5423 | 94 |
2431518 | 2431518 | 2022-04-22 | Columbia | Florida | 12023 | 21166 | 397 |
2431610 | 2431610 | 2022-04-22 | Columbia | Georgia | 13073 | 36010 | 384 |
2433046 | 2433046 | 2022-04-22 | Columbia | New York | 36021 | 10271 | 140 |
2433424 | 2433424 | 2022-04-22 | Columbia | Oregon | 41009 | 7667 | 93 |
2433474 | 2433474 | 2022-04-22 | Columbia | Pennsylvania | 42037 | 15184 | 244 |
2434257 | 2434257 | 2022-04-22 | Columbia | Washington | 53013 | 608 | 16 |
2434355 | 2434355 | 2022-04-22 | Columbia | Wisconsin | 55021 | 15349 | 127 |
2428052 | 2428052 | 2022-04-21 | Columbia | Arkansas | 5027 | 5423 | 94 |
2428262 | 2428262 | 2022-04-21 | Columbia | Florida | 12023 | 21140 | 397 |
2428354 | 2428354 | 2022-04-21 | Columbia | Georgia | 13073 | 36010 | 384 |
2429790 | 2429790 | 2022-04-21 | Columbia | New York | 36021 | 10252 | 140 |
2430168 | 2430168 | 2022-04-21 | Columbia | Oregon | 41009 | 7661 | 93 |
2430218 | 2430218 | 2022-04-21 | Columbia | Pennsylvania | 42037 | 15165 | 244 |
2431001 | 2431001 | 2022-04-21 | Columbia | Washington | 53013 | 608 | 16 |
2431099 | 2431099 | 2022-04-21 | Columbia | Wisconsin | 55021 | 15325 | 127 |
2424796 | 2424796 | 2022-04-20 | Columbia | Arkansas | 5027 | 5422 | 94 |
2425006 | 2425006 | 2022-04-20 | Columbia | Florida | 12023 | 21140 | 397 |
2425098 | 2425098 | 2022-04-20 | Columbia | Georgia | 13073 | 36010 | 384 |
2426534 | 2426534 | 2022-04-20 | Columbia | New York | 36021 | 10236 | 140 |
2426912 | 2426912 | 2022-04-20 | Columbia | Oregon | 41009 | 7640 | 93 |
2426962 | 2426962 | 2022-04-20 | Columbia | Pennsylvania | 42037 | 15158 | 244 |
2427745 | 2427745 | 2022-04-20 | Columbia | Washington | 53013 | 608 | 16 |
2427843 | 2427843 | 2022-04-20 | Columbia | Wisconsin | 55021 | 15317 | 127 |
2421540 | 2421540 | 2022-04-19 | Columbia | Arkansas | 5027 | 5422 | 94 |
2421750 | 2421750 | 2022-04-19 | Columbia | Florida | 12023 | 21140 | 393 |
2421842 | 2421842 | 2022-04-19 | Columbia | Georgia | 13073 | 35969 | 382 |
2423278 | 2423278 | 2022-04-19 | Columbia | New York | 36021 | 10219 | 140 |
2423656 | 2423656 | 2022-04-19 | Columbia | Oregon | 41009 | 7626 | 93 |
2423706 | 2423706 | 2022-04-19 | Columbia | Pennsylvania | 42037 | 15144 | 244 |
2424489 | 2424489 | 2022-04-19 | Columbia | Washington | 53013 | 608 | 16 |
2424587 | 2424587 | 2022-04-19 | Columbia | Wisconsin | 55021 | 15293 | 127 |
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);