ny_times_us_counties

Table actions
⚠️ 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

786 rows where fips = 5053 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 · 786 ✖

fips 1

  • 5053 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499712 2499712 2022-05-13 Grant Arkansas 5053 4468 61
2496454 2496454 2022-05-12 Grant Arkansas 5053 4466 61
2493196 2493196 2022-05-11 Grant Arkansas 5053 4467 61
2489938 2489938 2022-05-10 Grant Arkansas 5053 4465 61
2486681 2486681 2022-05-09 Grant Arkansas 5053 4464 61
2483423 2483423 2022-05-08 Grant Arkansas 5053 4464 61
2480165 2480165 2022-05-07 Grant Arkansas 5053 4463 61
2476907 2476907 2022-05-06 Grant Arkansas 5053 4464 61
2473649 2473649 2022-05-05 Grant Arkansas 5053 4464 61
2470392 2470392 2022-05-04 Grant Arkansas 5053 4464 61
2467136 2467136 2022-05-03 Grant Arkansas 5053 4464 61
2463881 2463881 2022-05-02 Grant Arkansas 5053 4464 61
2460625 2460625 2022-05-01 Grant Arkansas 5053 4464 61
2457369 2457369 2022-04-30 Grant Arkansas 5053 4464 61
2454113 2454113 2022-04-29 Grant Arkansas 5053 4464 61
2450857 2450857 2022-04-28 Grant Arkansas 5053 4464 61
2447601 2447601 2022-04-27 Grant Arkansas 5053 4462 61
2444345 2444345 2022-04-26 Grant Arkansas 5053 4462 61
2441089 2441089 2022-04-25 Grant Arkansas 5053 4462 61
2437833 2437833 2022-04-24 Grant Arkansas 5053 4462 61
2434577 2434577 2022-04-23 Grant Arkansas 5053 4462 61
2431321 2431321 2022-04-22 Grant Arkansas 5053 4462 61
2428065 2428065 2022-04-21 Grant Arkansas 5053 4462 61
2424809 2424809 2022-04-20 Grant Arkansas 5053 4462 61
2421553 2421553 2022-04-19 Grant Arkansas 5053 4462 61
2418297 2418297 2022-04-18 Grant Arkansas 5053 4462 61
2415041 2415041 2022-04-17 Grant Arkansas 5053 4462 61
2411785 2411785 2022-04-16 Grant Arkansas 5053 4462 61
2408529 2408529 2022-04-15 Grant Arkansas 5053 4462 61
2405273 2405273 2022-04-14 Grant Arkansas 5053 4461 61
2402018 2402018 2022-04-13 Grant Arkansas 5053 4461 61
2398763 2398763 2022-04-12 Grant Arkansas 5053 4460 61
2395508 2395508 2022-04-11 Grant Arkansas 5053 4460 61
2392252 2392252 2022-04-10 Grant Arkansas 5053 4460 61
2388996 2388996 2022-04-09 Grant Arkansas 5053 4460 61
2385741 2385741 2022-04-08 Grant Arkansas 5053 4460 61
2382486 2382486 2022-04-07 Grant Arkansas 5053 4460 61
2379231 2379231 2022-04-06 Grant Arkansas 5053 4458 61
2375977 2375977 2022-04-05 Grant Arkansas 5053 4457 61
2372725 2372725 2022-04-04 Grant Arkansas 5053 4457 61
2369472 2369472 2022-04-03 Grant Arkansas 5053 4457 61
2366219 2366219 2022-04-02 Grant Arkansas 5053 4457 61
2362966 2362966 2022-04-01 Grant Arkansas 5053 4457 60
2359712 2359712 2022-03-31 Grant Arkansas 5053 4456 60
2356458 2356458 2022-03-30 Grant Arkansas 5053 4456 60
2353205 2353205 2022-03-29 Grant Arkansas 5053 4456 60
2349953 2349953 2022-03-28 Grant Arkansas 5053 4456 60
2346700 2346700 2022-03-27 Grant Arkansas 5053 4455 60
2343447 2343447 2022-03-26 Grant Arkansas 5053 4455 60
2340194 2340194 2022-03-25 Grant Arkansas 5053 4453 60
2336941 2336941 2022-03-24 Grant Arkansas 5053 4452 60
2333687 2333687 2022-03-23 Grant Arkansas 5053 4451 60
2330433 2330433 2022-03-22 Grant Arkansas 5053 4450 59
2327181 2327181 2022-03-21 Grant Arkansas 5053 4445 59
2323928 2323928 2022-03-20 Grant Arkansas 5053 4444 59
2320674 2320674 2022-03-19 Grant Arkansas 5053 4434 59
2317420 2317420 2022-03-18 Grant Arkansas 5053 4426 59
2314167 2314167 2022-03-17 Grant Arkansas 5053 4408 59
2310914 2310914 2022-03-16 Grant Arkansas 5053 4406 59
2307661 2307661 2022-03-15 Grant Arkansas 5053 4404 59
2304410 2304410 2022-03-14 Grant Arkansas 5053 4404 59
2301158 2301158 2022-03-13 Grant Arkansas 5053 4402 59
2297906 2297906 2022-03-12 Grant Arkansas 5053 4399 59
2294654 2294654 2022-03-11 Grant Arkansas 5053 4396 59
2291402 2291402 2022-03-10 Grant Arkansas 5053 4394 59
2288150 2288150 2022-03-09 Grant Arkansas 5053 4390 59
2284899 2284899 2022-03-08 Grant Arkansas 5053 4384 59
2281647 2281647 2022-03-07 Grant Arkansas 5053 4381 59
2278394 2278394 2022-03-06 Grant Arkansas 5053 4381 59
2275141 2275141 2022-03-05 Grant Arkansas 5053 4378 59
2271888 2271888 2022-03-04 Grant Arkansas 5053 4368 58
2268636 2268636 2022-03-03 Grant Arkansas 5053 4367 58
2265383 2265383 2022-03-02 Grant Arkansas 5053 4367 58
2262132 2262132 2022-03-01 Grant Arkansas 5053 4365 58
2258881 2258881 2022-02-28 Grant Arkansas 5053 4363 58
2255630 2255630 2022-02-27 Grant Arkansas 5053 4359 58
2252379 2252379 2022-02-26 Grant Arkansas 5053 4355 58
2249128 2249128 2022-02-25 Grant Arkansas 5053 4351 57
2245877 2245877 2022-02-24 Grant Arkansas 5053 4351 57
2242626 2242626 2022-02-23 Grant Arkansas 5053 4334 56
2239375 2239375 2022-02-22 Grant Arkansas 5053 4331 56
2236124 2236124 2022-02-21 Grant Arkansas 5053 4315 56
2232873 2232873 2022-02-20 Grant Arkansas 5053 4314 56
2229622 2229622 2022-02-19 Grant Arkansas 5053 4314 56
2226371 2226371 2022-02-18 Grant Arkansas 5053 4310 56
2223120 2223120 2022-02-17 Grant Arkansas 5053 4303 56
2219869 2219869 2022-02-16 Grant Arkansas 5053 4287 56
2216618 2216618 2022-02-15 Grant Arkansas 5053 4280 55
2213367 2213367 2022-02-14 Grant Arkansas 5053 4272 55
2210115 2210115 2022-02-13 Grant Arkansas 5053 4271 55
2206862 2206862 2022-02-12 Grant Arkansas 5053 4269 55
2203609 2203609 2022-02-11 Grant Arkansas 5053 4257 55
2200356 2200356 2022-02-10 Grant Arkansas 5053 4249 55
2197102 2197102 2022-02-09 Grant Arkansas 5053 4235 55
2193847 2193847 2022-02-08 Grant Arkansas 5053 4221 55
2190594 2190594 2022-02-07 Grant Arkansas 5053 4209 55
2187341 2187341 2022-02-06 Grant Arkansas 5053 4204 55
2184088 2184088 2022-02-05 Grant Arkansas 5053 4191 55
2180836 2180836 2022-02-04 Grant Arkansas 5053 4188 54
2177585 2177585 2022-02-03 Grant Arkansas 5053 4180 54

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);