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

751 rows where fips = 5049 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 5049 · 751 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499710 2499710 2022-05-13 Fulton Arkansas 5049 2696 90
2496452 2496452 2022-05-12 Fulton Arkansas 5049 2696 90
2493194 2493194 2022-05-11 Fulton Arkansas 5049 2696 90
2489936 2489936 2022-05-10 Fulton Arkansas 5049 2693 90
2486679 2486679 2022-05-09 Fulton Arkansas 5049 2692 90
2483421 2483421 2022-05-08 Fulton Arkansas 5049 2692 90
2480163 2480163 2022-05-07 Fulton Arkansas 5049 2692 90
2476905 2476905 2022-05-06 Fulton Arkansas 5049 2692 90
2473647 2473647 2022-05-05 Fulton Arkansas 5049 2692 90
2470390 2470390 2022-05-04 Fulton Arkansas 5049 2691 90
2467134 2467134 2022-05-03 Fulton Arkansas 5049 2691 90
2463879 2463879 2022-05-02 Fulton Arkansas 5049 2691 90
2460623 2460623 2022-05-01 Fulton Arkansas 5049 2691 90
2457367 2457367 2022-04-30 Fulton Arkansas 5049 2691 90
2454111 2454111 2022-04-29 Fulton Arkansas 5049 2691 90
2450855 2450855 2022-04-28 Fulton Arkansas 5049 2691 90
2447599 2447599 2022-04-27 Fulton Arkansas 5049 2691 90
2444343 2444343 2022-04-26 Fulton Arkansas 5049 2691 90
2441087 2441087 2022-04-25 Fulton Arkansas 5049 2690 90
2437831 2437831 2022-04-24 Fulton Arkansas 5049 2690 90
2434575 2434575 2022-04-23 Fulton Arkansas 5049 2689 90
2431319 2431319 2022-04-22 Fulton Arkansas 5049 2688 90
2428063 2428063 2022-04-21 Fulton Arkansas 5049 2688 90
2424807 2424807 2022-04-20 Fulton Arkansas 5049 2688 90
2421551 2421551 2022-04-19 Fulton Arkansas 5049 2689 90
2418295 2418295 2022-04-18 Fulton Arkansas 5049 2689 90
2415039 2415039 2022-04-17 Fulton Arkansas 5049 2689 90
2411783 2411783 2022-04-16 Fulton Arkansas 5049 2689 90
2408527 2408527 2022-04-15 Fulton Arkansas 5049 2689 90
2405271 2405271 2022-04-14 Fulton Arkansas 5049 2690 90
2402016 2402016 2022-04-13 Fulton Arkansas 5049 2690 90
2398761 2398761 2022-04-12 Fulton Arkansas 5049 2690 90
2395506 2395506 2022-04-11 Fulton Arkansas 5049 2689 90
2392250 2392250 2022-04-10 Fulton Arkansas 5049 2689 90
2388994 2388994 2022-04-09 Fulton Arkansas 5049 2689 90
2385739 2385739 2022-04-08 Fulton Arkansas 5049 2689 90
2382484 2382484 2022-04-07 Fulton Arkansas 5049 2689 90
2379229 2379229 2022-04-06 Fulton Arkansas 5049 2689 89
2375975 2375975 2022-04-05 Fulton Arkansas 5049 2688 89
2372723 2372723 2022-04-04 Fulton Arkansas 5049 2687 89
2369470 2369470 2022-04-03 Fulton Arkansas 5049 2687 89
2366217 2366217 2022-04-02 Fulton Arkansas 5049 2687 89
2362964 2362964 2022-04-01 Fulton Arkansas 5049 2687 88
2359710 2359710 2022-03-31 Fulton Arkansas 5049 2688 88
2356456 2356456 2022-03-30 Fulton Arkansas 5049 2688 88
2353203 2353203 2022-03-29 Fulton Arkansas 5049 2688 88
2349951 2349951 2022-03-28 Fulton Arkansas 5049 2687 88
2346698 2346698 2022-03-27 Fulton Arkansas 5049 2687 88
2343445 2343445 2022-03-26 Fulton Arkansas 5049 2686 88
2340192 2340192 2022-03-25 Fulton Arkansas 5049 2685 88
2336939 2336939 2022-03-24 Fulton Arkansas 5049 2685 88
2333685 2333685 2022-03-23 Fulton Arkansas 5049 2685 88
2330431 2330431 2022-03-22 Fulton Arkansas 5049 2685 88
2327179 2327179 2022-03-21 Fulton Arkansas 5049 2684 88
2323926 2323926 2022-03-20 Fulton Arkansas 5049 2682 88
2320672 2320672 2022-03-19 Fulton Arkansas 5049 2682 88
2317418 2317418 2022-03-18 Fulton Arkansas 5049 2676 88
2314165 2314165 2022-03-17 Fulton Arkansas 5049 2667 87
2310912 2310912 2022-03-16 Fulton Arkansas 5049 2665 87
2307659 2307659 2022-03-15 Fulton Arkansas 5049 2664 87
2304408 2304408 2022-03-14 Fulton Arkansas 5049 2663 87
2301156 2301156 2022-03-13 Fulton Arkansas 5049 2662 86
2297904 2297904 2022-03-12 Fulton Arkansas 5049 2662 86
2294652 2294652 2022-03-11 Fulton Arkansas 5049 2659 86
2291400 2291400 2022-03-10 Fulton Arkansas 5049 2660 86
2288148 2288148 2022-03-09 Fulton Arkansas 5049 2655 85
2284897 2284897 2022-03-08 Fulton Arkansas 5049 2655 85
2281645 2281645 2022-03-07 Fulton Arkansas 5049 2652 85
2278392 2278392 2022-03-06 Fulton Arkansas 5049 2651 85
2275139 2275139 2022-03-05 Fulton Arkansas 5049 2651 85
2271886 2271886 2022-03-04 Fulton Arkansas 5049 2647 85
2268634 2268634 2022-03-03 Fulton Arkansas 5049 2645 85
2265381 2265381 2022-03-02 Fulton Arkansas 5049 2643 84
2262130 2262130 2022-03-01 Fulton Arkansas 5049 2641 84
2258879 2258879 2022-02-28 Fulton Arkansas 5049 2638 83
2255628 2255628 2022-02-27 Fulton Arkansas 5049 2638 83
2252377 2252377 2022-02-26 Fulton Arkansas 5049 2637 83
2249126 2249126 2022-02-25 Fulton Arkansas 5049 2637 83
2245875 2245875 2022-02-24 Fulton Arkansas 5049 2637 83
2242624 2242624 2022-02-23 Fulton Arkansas 5049 2637 83
2239373 2239373 2022-02-22 Fulton Arkansas 5049 2633 83
2236122 2236122 2022-02-21 Fulton Arkansas 5049 2630 83
2232871 2232871 2022-02-20 Fulton Arkansas 5049 2629 83
2229620 2229620 2022-02-19 Fulton Arkansas 5049 2627 83
2226369 2226369 2022-02-18 Fulton Arkansas 5049 2622 83
2223118 2223118 2022-02-17 Fulton Arkansas 5049 2612 83
2219867 2219867 2022-02-16 Fulton Arkansas 5049 2610 83
2216616 2216616 2022-02-15 Fulton Arkansas 5049 2609 83
2213365 2213365 2022-02-14 Fulton Arkansas 5049 2604 83
2210113 2210113 2022-02-13 Fulton Arkansas 5049 2601 83
2206860 2206860 2022-02-12 Fulton Arkansas 5049 2600 83
2203607 2203607 2022-02-11 Fulton Arkansas 5049 2599 81
2200354 2200354 2022-02-10 Fulton Arkansas 5049 2592 81
2197100 2197100 2022-02-09 Fulton Arkansas 5049 2584 81
2193845 2193845 2022-02-08 Fulton Arkansas 5049 2582 81
2190592 2190592 2022-02-07 Fulton Arkansas 5049 2596 82
2187339 2187339 2022-02-06 Fulton Arkansas 5049 2594 82
2184086 2184086 2022-02-05 Fulton Arkansas 5049 2592 82
2180834 2180834 2022-02-04 Fulton Arkansas 5049 2589 82
2177583 2177583 2022-02-03 Fulton Arkansas 5049 2583 81

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