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

785 rows where fips = 13287 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

  • 13287 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500107 2500107 2022-05-13 Turner Georgia 13287 2569 61
2496849 2496849 2022-05-12 Turner Georgia 13287 2569 61
2493591 2493591 2022-05-11 Turner Georgia 13287 2569 61
2490333 2490333 2022-05-10 Turner Georgia 13287 2565 60
2487076 2487076 2022-05-09 Turner Georgia 13287 2565 60
2483818 2483818 2022-05-08 Turner Georgia 13287 2565 60
2480560 2480560 2022-05-07 Turner Georgia 13287 2565 60
2477302 2477302 2022-05-06 Turner Georgia 13287 2565 60
2474044 2474044 2022-05-05 Turner Georgia 13287 2565 60
2470787 2470787 2022-05-04 Turner Georgia 13287 2565 60
2467531 2467531 2022-05-03 Turner Georgia 13287 2562 60
2464276 2464276 2022-05-02 Turner Georgia 13287 2562 60
2461020 2461020 2022-05-01 Turner Georgia 13287 2562 60
2457764 2457764 2022-04-30 Turner Georgia 13287 2562 60
2454508 2454508 2022-04-29 Turner Georgia 13287 2562 60
2451252 2451252 2022-04-28 Turner Georgia 13287 2562 60
2447996 2447996 2022-04-27 Turner Georgia 13287 2562 60
2444740 2444740 2022-04-26 Turner Georgia 13287 2552 60
2441484 2441484 2022-04-25 Turner Georgia 13287 2552 60
2438228 2438228 2022-04-24 Turner Georgia 13287 2552 60
2434972 2434972 2022-04-23 Turner Georgia 13287 2552 60
2431716 2431716 2022-04-22 Turner Georgia 13287 2552 60
2428460 2428460 2022-04-21 Turner Georgia 13287 2552 60
2425204 2425204 2022-04-20 Turner Georgia 13287 2552 60
2421948 2421948 2022-04-19 Turner Georgia 13287 2546 60
2418692 2418692 2022-04-18 Turner Georgia 13287 2546 60
2415436 2415436 2022-04-17 Turner Georgia 13287 2546 60
2412180 2412180 2022-04-16 Turner Georgia 13287 2546 60
2408924 2408924 2022-04-15 Turner Georgia 13287 2546 60
2405668 2405668 2022-04-14 Turner Georgia 13287 2545 60
2402413 2402413 2022-04-13 Turner Georgia 13287 2545 60
2399158 2399158 2022-04-12 Turner Georgia 13287 2544 60
2395903 2395903 2022-04-11 Turner Georgia 13287 2543 60
2392647 2392647 2022-04-10 Turner Georgia 13287 2543 60
2389391 2389391 2022-04-09 Turner Georgia 13287 2543 60
2386136 2386136 2022-04-08 Turner Georgia 13287 2543 60
2382881 2382881 2022-04-07 Turner Georgia 13287 2543 60
2379626 2379626 2022-04-06 Turner Georgia 13287 2543 59
2376372 2376372 2022-04-05 Turner Georgia 13287 2543 59
2373120 2373120 2022-04-04 Turner Georgia 13287 2543 59
2369867 2369867 2022-04-03 Turner Georgia 13287 2542 59
2366614 2366614 2022-04-02 Turner Georgia 13287 2542 59
2363361 2363361 2022-04-01 Turner Georgia 13287 2542 59
2360107 2360107 2022-03-31 Turner Georgia 13287 2542 58
2356853 2356853 2022-03-30 Turner Georgia 13287 2542 58
2353600 2353600 2022-03-29 Turner Georgia 13287 2542 58
2350348 2350348 2022-03-28 Turner Georgia 13287 2542 58
2347095 2347095 2022-03-27 Turner Georgia 13287 2542 58
2343842 2343842 2022-03-26 Turner Georgia 13287 2542 58
2340589 2340589 2022-03-25 Turner Georgia 13287 2542 58
2337336 2337336 2022-03-24 Turner Georgia 13287 2542 58
2334082 2334082 2022-03-23 Turner Georgia 13287 2542 58
2330828 2330828 2022-03-22 Turner Georgia 13287 2542 58
2327576 2327576 2022-03-21 Turner Georgia 13287 2541 58
2324323 2324323 2022-03-20 Turner Georgia 13287 2541 58
2321069 2321069 2022-03-19 Turner Georgia 13287 2541 58
2317815 2317815 2022-03-18 Turner Georgia 13287 2541 58
2314562 2314562 2022-03-17 Turner Georgia 13287 2541 57
2311309 2311309 2022-03-16 Turner Georgia 13287 2541 57
2308056 2308056 2022-03-15 Turner Georgia 13287 2541 57
2304805 2304805 2022-03-14 Turner Georgia 13287 2541 57
2301553 2301553 2022-03-13 Turner Georgia 13287 2541 55
2298301 2298301 2022-03-12 Turner Georgia 13287 2541 55
2295049 2295049 2022-03-11 Turner Georgia 13287 2541 55
2291797 2291797 2022-03-10 Turner Georgia 13287 2541 55
2288545 2288545 2022-03-09 Turner Georgia 13287 2541 55
2285294 2285294 2022-03-08 Turner Georgia 13287 2540 55
2282042 2282042 2022-03-07 Turner Georgia 13287 2540 55
2278789 2278789 2022-03-06 Turner Georgia 13287 2539 55
2275536 2275536 2022-03-05 Turner Georgia 13287 2539 55
2272283 2272283 2022-03-04 Turner Georgia 13287 2539 55
2269031 2269031 2022-03-03 Turner Georgia 13287 2538 55
2265778 2265778 2022-03-02 Turner Georgia 13287 2536 55
2262527 2262527 2022-03-01 Turner Georgia 13287 2536 54
2259276 2259276 2022-02-28 Turner Georgia 13287 2535 53
2256025 2256025 2022-02-27 Turner Georgia 13287 2533 53
2252774 2252774 2022-02-26 Turner Georgia 13287 2533 53
2249523 2249523 2022-02-25 Turner Georgia 13287 2533 53
2246272 2246272 2022-02-24 Turner Georgia 13287 2531 53
2243021 2243021 2022-02-23 Turner Georgia 13287 2530 53
2239770 2239770 2022-02-22 Turner Georgia 13287 2526 53
2236519 2236519 2022-02-21 Turner Georgia 13287 2519 53
2233268 2233268 2022-02-20 Turner Georgia 13287 2516 53
2230017 2230017 2022-02-19 Turner Georgia 13287 2516 53
2226766 2226766 2022-02-18 Turner Georgia 13287 2516 53
2223515 2223515 2022-02-17 Turner Georgia 13287 2516 53
2220264 2220264 2022-02-16 Turner Georgia 13287 2511 53
2217013 2217013 2022-02-15 Turner Georgia 13287 2504 53
2213762 2213762 2022-02-14 Turner Georgia 13287 2502 53
2210510 2210510 2022-02-13 Turner Georgia 13287 2498 52
2207257 2207257 2022-02-12 Turner Georgia 13287 2498 52
2204004 2204004 2022-02-11 Turner Georgia 13287 2498 52
2200751 2200751 2022-02-10 Turner Georgia 13287 2496 52
2197497 2197497 2022-02-09 Turner Georgia 13287 2492 52
2194243 2194243 2022-02-08 Turner Georgia 13287 2490 51
2190989 2190989 2022-02-07 Turner Georgia 13287 2485 51
2187736 2187736 2022-02-06 Turner Georgia 13287 2478 50
2184483 2184483 2022-02-05 Turner Georgia 13287 2478 50
2181231 2181231 2022-02-04 Turner Georgia 13287 2478 50
2177980 2177980 2022-02-03 Turner Georgia 13287 2470 50

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