home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

781 rows where county = "Columbia" and state = "Arkansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Arkansas · 781 ✖

fips 1

  • 5027 781

county 1

  • Columbia · 781 ✖
Link rowid date ▲ county state fips cases deaths
2499699 2499699 2022-05-13 Columbia Arkansas 5027 5438 95
2496441 2496441 2022-05-12 Columbia Arkansas 5027 5436 95
2493183 2493183 2022-05-11 Columbia Arkansas 5027 5430 95
2489925 2489925 2022-05-10 Columbia Arkansas 5027 5430 95
2486668 2486668 2022-05-09 Columbia Arkansas 5027 5430 95
2483410 2483410 2022-05-08 Columbia Arkansas 5027 5430 95
2480152 2480152 2022-05-07 Columbia Arkansas 5027 5429 95
2476894 2476894 2022-05-06 Columbia Arkansas 5027 5428 95
2473636 2473636 2022-05-05 Columbia Arkansas 5027 5428 95
2470379 2470379 2022-05-04 Columbia Arkansas 5027 5427 95
2467123 2467123 2022-05-03 Columbia Arkansas 5027 5427 95
2463868 2463868 2022-05-02 Columbia Arkansas 5027 5427 95
2460612 2460612 2022-05-01 Columbia Arkansas 5027 5427 95
2457356 2457356 2022-04-30 Columbia Arkansas 5027 5427 95
2454100 2454100 2022-04-29 Columbia Arkansas 5027 5426 95
2450844 2450844 2022-04-28 Columbia Arkansas 5027 5426 95
2447588 2447588 2022-04-27 Columbia Arkansas 5027 5425 94
2444332 2444332 2022-04-26 Columbia Arkansas 5027 5425 94
2441076 2441076 2022-04-25 Columbia Arkansas 5027 5424 94
2437820 2437820 2022-04-24 Columbia Arkansas 5027 5424 94
2434564 2434564 2022-04-23 Columbia Arkansas 5027 5424 94
2431308 2431308 2022-04-22 Columbia Arkansas 5027 5423 94
2428052 2428052 2022-04-21 Columbia Arkansas 5027 5423 94
2424796 2424796 2022-04-20 Columbia Arkansas 5027 5422 94
2421540 2421540 2022-04-19 Columbia Arkansas 5027 5422 94
2418284 2418284 2022-04-18 Columbia Arkansas 5027 5420 94
2415028 2415028 2022-04-17 Columbia Arkansas 5027 5420 94
2411772 2411772 2022-04-16 Columbia Arkansas 5027 5419 94
2408516 2408516 2022-04-15 Columbia Arkansas 5027 5419 94
2405260 2405260 2022-04-14 Columbia Arkansas 5027 5418 94
2402005 2402005 2022-04-13 Columbia Arkansas 5027 5417 94
2398750 2398750 2022-04-12 Columbia Arkansas 5027 5417 94
2395495 2395495 2022-04-11 Columbia Arkansas 5027 5416 94
2392239 2392239 2022-04-10 Columbia Arkansas 5027 5416 93
2388983 2388983 2022-04-09 Columbia Arkansas 5027 5416 92
2385728 2385728 2022-04-08 Columbia Arkansas 5027 5416 91
2382473 2382473 2022-04-07 Columbia Arkansas 5027 5415 91
2379218 2379218 2022-04-06 Columbia Arkansas 5027 5415 91
2375964 2375964 2022-04-05 Columbia Arkansas 5027 5416 91
2372712 2372712 2022-04-04 Columbia Arkansas 5027 5416 91
2369459 2369459 2022-04-03 Columbia Arkansas 5027 5416 91
2366206 2366206 2022-04-02 Columbia Arkansas 5027 5416 91
2362953 2362953 2022-04-01 Columbia Arkansas 5027 5416 91
2359699 2359699 2022-03-31 Columbia Arkansas 5027 5416 91
2356445 2356445 2022-03-30 Columbia Arkansas 5027 5416 91
2353192 2353192 2022-03-29 Columbia Arkansas 5027 5414 91
2349940 2349940 2022-03-28 Columbia Arkansas 5027 5414 91
2346687 2346687 2022-03-27 Columbia Arkansas 5027 5414 91
2343434 2343434 2022-03-26 Columbia Arkansas 5027 5414 91
2340181 2340181 2022-03-25 Columbia Arkansas 5027 5414 91
2336928 2336928 2022-03-24 Columbia Arkansas 5027 5406 91
2333674 2333674 2022-03-23 Columbia Arkansas 5027 5405 91
2330420 2330420 2022-03-22 Columbia Arkansas 5027 5403 91
2327168 2327168 2022-03-21 Columbia Arkansas 5027 5396 90
2323915 2323915 2022-03-20 Columbia Arkansas 5027 5388 90
2320661 2320661 2022-03-19 Columbia Arkansas 5027 5376 90
2317407 2317407 2022-03-18 Columbia Arkansas 5027 5366 90
2314154 2314154 2022-03-17 Columbia Arkansas 5027 5352 90
2310901 2310901 2022-03-16 Columbia Arkansas 5027 5347 90
2307648 2307648 2022-03-15 Columbia Arkansas 5027 5346 90
2304397 2304397 2022-03-14 Columbia Arkansas 5027 5343 90
2301145 2301145 2022-03-13 Columbia Arkansas 5027 5340 90
2297893 2297893 2022-03-12 Columbia Arkansas 5027 5340 90
2294641 2294641 2022-03-11 Columbia Arkansas 5027 5324 90
2291389 2291389 2022-03-10 Columbia Arkansas 5027 5319 89
2288137 2288137 2022-03-09 Columbia Arkansas 5027 5302 89
2284886 2284886 2022-03-08 Columbia Arkansas 5027 5297 89
2281634 2281634 2022-03-07 Columbia Arkansas 5027 5297 89
2278381 2278381 2022-03-06 Columbia Arkansas 5027 5297 89
2275128 2275128 2022-03-05 Columbia Arkansas 5027 5297 89
2271875 2271875 2022-03-04 Columbia Arkansas 5027 5296 89
2268623 2268623 2022-03-03 Columbia Arkansas 5027 5293 89
2265370 2265370 2022-03-02 Columbia Arkansas 5027 5293 89
2262119 2262119 2022-03-01 Columbia Arkansas 5027 5290 87
2258868 2258868 2022-02-28 Columbia Arkansas 5027 5280 86
2255617 2255617 2022-02-27 Columbia Arkansas 5027 5270 85
2252366 2252366 2022-02-26 Columbia Arkansas 5027 5261 85
2249115 2249115 2022-02-25 Columbia Arkansas 5027 5245 83
2245864 2245864 2022-02-24 Columbia Arkansas 5027 5243 83
2242613 2242613 2022-02-23 Columbia Arkansas 5027 5228 82
2239362 2239362 2022-02-22 Columbia Arkansas 5027 5207 81
2236111 2236111 2022-02-21 Columbia Arkansas 5027 5204 81
2232860 2232860 2022-02-20 Columbia Arkansas 5027 5195 81
2229609 2229609 2022-02-19 Columbia Arkansas 5027 5191 81
2226358 2226358 2022-02-18 Columbia Arkansas 5027 5184 81
2223107 2223107 2022-02-17 Columbia Arkansas 5027 5178 81
2219856 2219856 2022-02-16 Columbia Arkansas 5027 5169 80
2216605 2216605 2022-02-15 Columbia Arkansas 5027 5166 79
2213354 2213354 2022-02-14 Columbia Arkansas 5027 5164 79
2210102 2210102 2022-02-13 Columbia Arkansas 5027 5160 79
2206849 2206849 2022-02-12 Columbia Arkansas 5027 5158 79
2203596 2203596 2022-02-11 Columbia Arkansas 5027 5127 78
2200343 2200343 2022-02-10 Columbia Arkansas 5027 5097 77
2197089 2197089 2022-02-09 Columbia Arkansas 5027 5056 77
2193834 2193834 2022-02-08 Columbia Arkansas 5027 5047 77
2190581 2190581 2022-02-07 Columbia Arkansas 5027 5036 77
2187328 2187328 2022-02-06 Columbia Arkansas 5027 5036 77
2184075 2184075 2022-02-05 Columbia Arkansas 5027 5026 77
2180823 2180823 2022-02-04 Columbia Arkansas 5027 5010 77
2177572 2177572 2022-02-03 Columbia Arkansas 5027 5004 77

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 802.738ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette