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

785 rows where county = "Rapides" and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana · 785 ✖

fips 1

  • 22079 785

county 1

  • Rapides · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500738 2500738 2022-05-13 Rapides Louisiana 22079 32791 577
2497480 2497480 2022-05-12 Rapides Louisiana 22079 32783 577
2494222 2494222 2022-05-11 Rapides Louisiana 22079 32774 577
2490964 2490964 2022-05-10 Rapides Louisiana 22079 32772 577
2487707 2487707 2022-05-09 Rapides Louisiana 22079 32771 577
2484449 2484449 2022-05-08 Rapides Louisiana 22079 32768 577
2481191 2481191 2022-05-07 Rapides Louisiana 22079 32768 577
2477933 2477933 2022-05-06 Rapides Louisiana 22079 32768 577
2474675 2474675 2022-05-05 Rapides Louisiana 22079 32764 577
2471418 2471418 2022-05-04 Rapides Louisiana 22079 32756 577
2468162 2468162 2022-05-03 Rapides Louisiana 22079 32754 577
2464907 2464907 2022-05-02 Rapides Louisiana 22079 32745 577
2461651 2461651 2022-05-01 Rapides Louisiana 22079 32743 577
2458395 2458395 2022-04-30 Rapides Louisiana 22079 32743 577
2455139 2455139 2022-04-29 Rapides Louisiana 22079 32743 577
2451883 2451883 2022-04-28 Rapides Louisiana 22079 32741 576
2448627 2448627 2022-04-27 Rapides Louisiana 22079 32737 576
2445371 2445371 2022-04-26 Rapides Louisiana 22079 32734 576
2442115 2442115 2022-04-25 Rapides Louisiana 22079 32734 575
2438859 2438859 2022-04-24 Rapides Louisiana 22079 32730 575
2435603 2435603 2022-04-23 Rapides Louisiana 22079 32730 575
2432347 2432347 2022-04-22 Rapides Louisiana 22079 32730 575
2429091 2429091 2022-04-21 Rapides Louisiana 22079 32730 575
2425835 2425835 2022-04-20 Rapides Louisiana 22079 32730 575
2422579 2422579 2022-04-19 Rapides Louisiana 22079 32727 575
2419323 2419323 2022-04-18 Rapides Louisiana 22079 32724 575
2416067 2416067 2022-04-17 Rapides Louisiana 22079 32724 575
2412811 2412811 2022-04-16 Rapides Louisiana 22079 32724 575
2409555 2409555 2022-04-15 Rapides Louisiana 22079 32724 575
2406299 2406299 2022-04-14 Rapides Louisiana 22079 32724 575
2403043 2403043 2022-04-13 Rapides Louisiana 22079 32723 575
2399789 2399789 2022-04-12 Rapides Louisiana 22079 32719 575
2396533 2396533 2022-04-11 Rapides Louisiana 22079 32719 575
2393278 2393278 2022-04-10 Rapides Louisiana 22079 32718 575
2390022 2390022 2022-04-09 Rapides Louisiana 22079 32718 575
2386766 2386766 2022-04-08 Rapides Louisiana 22079 32718 575
2383511 2383511 2022-04-07 Rapides Louisiana 22079 32716 575
2380256 2380256 2022-04-06 Rapides Louisiana 22079 32715 575
2377001 2377001 2022-04-05 Rapides Louisiana 22079 32713 575
2373749 2373749 2022-04-04 Rapides Louisiana 22079 32710 575
2370496 2370496 2022-04-03 Rapides Louisiana 22079 32710 575
2367243 2367243 2022-04-02 Rapides Louisiana 22079 32710 575
2363990 2363990 2022-04-01 Rapides Louisiana 22079 32710 575
2360736 2360736 2022-03-31 Rapides Louisiana 22079 32708 575
2357482 2357482 2022-03-30 Rapides Louisiana 22079 32708 575
2354229 2354229 2022-03-29 Rapides Louisiana 22079 32704 575
2350977 2350977 2022-03-28 Rapides Louisiana 22079 32702 574
2347724 2347724 2022-03-27 Rapides Louisiana 22079 32698 573
2344471 2344471 2022-03-26 Rapides Louisiana 22079 32698 573
2341218 2341218 2022-03-25 Rapides Louisiana 22079 32698 573
2337965 2337965 2022-03-24 Rapides Louisiana 22079 32696 572
2334711 2334711 2022-03-23 Rapides Louisiana 22079 32690 572
2331457 2331457 2022-03-22 Rapides Louisiana 22079 32685 572
2328205 2328205 2022-03-21 Rapides Louisiana 22079 32680 572
2324952 2324952 2022-03-20 Rapides Louisiana 22079 32677 570
2321698 2321698 2022-03-19 Rapides Louisiana 22079 32677 570
2318444 2318444 2022-03-18 Rapides Louisiana 22079 32677 570
2315191 2315191 2022-03-17 Rapides Louisiana 22079 32673 569
2311938 2311938 2022-03-16 Rapides Louisiana 22079 32664 569
2308685 2308685 2022-03-15 Rapides Louisiana 22079 32663 569
2305434 2305434 2022-03-14 Rapides Louisiana 22079 32657 564
2302182 2302182 2022-03-13 Rapides Louisiana 22079 32647 563
2298930 2298930 2022-03-12 Rapides Louisiana 22079 32647 563
2295678 2295678 2022-03-11 Rapides Louisiana 22079 32647 563
2292426 2292426 2022-03-10 Rapides Louisiana 22079 32645 561
2289174 2289174 2022-03-09 Rapides Louisiana 22079 32638 560
2285923 2285923 2022-03-08 Rapides Louisiana 22079 32627 560
2282671 2282671 2022-03-07 Rapides Louisiana 22079 32623 557
2279418 2279418 2022-03-06 Rapides Louisiana 22079 32613 557
2276165 2276165 2022-03-05 Rapides Louisiana 22079 32613 557
2272912 2272912 2022-03-04 Rapides Louisiana 22079 32613 557
2269660 2269660 2022-03-03 Rapides Louisiana 22079 32609 554
2266407 2266407 2022-03-02 Rapides Louisiana 22079 32589 553
2263156 2263156 2022-03-01 Rapides Louisiana 22079 32563 553
2259905 2259905 2022-02-28 Rapides Louisiana 22079 32563 553
2256654 2256654 2022-02-27 Rapides Louisiana 22079 32563 553
2253403 2253403 2022-02-26 Rapides Louisiana 22079 32563 553
2250152 2250152 2022-02-25 Rapides Louisiana 22079 32563 553
2246901 2246901 2022-02-24 Rapides Louisiana 22079 32556 551
2243650 2243650 2022-02-23 Rapides Louisiana 22079 32543 551
2240399 2240399 2022-02-22 Rapides Louisiana 22079 32530 551
2237148 2237148 2022-02-21 Rapides Louisiana 22079 32466 548
2233897 2233897 2022-02-20 Rapides Louisiana 22079 32430 546
2230646 2230646 2022-02-19 Rapides Louisiana 22079 32430 546
2227395 2227395 2022-02-18 Rapides Louisiana 22079 32430 546
2224144 2224144 2022-02-17 Rapides Louisiana 22079 32412 543
2220893 2220893 2022-02-16 Rapides Louisiana 22079 32387 540
2217642 2217642 2022-02-15 Rapides Louisiana 22079 32354 539
2214391 2214391 2022-02-14 Rapides Louisiana 22079 32282 537
2211139 2211139 2022-02-13 Rapides Louisiana 22079 32225 533
2207886 2207886 2022-02-12 Rapides Louisiana 22079 32225 533
2204633 2204633 2022-02-11 Rapides Louisiana 22079 32225 533
2201380 2201380 2022-02-10 Rapides Louisiana 22079 32112 529
2198126 2198126 2022-02-09 Rapides Louisiana 22079 32056 528
2194872 2194872 2022-02-08 Rapides Louisiana 22079 31986 524
2191618 2191618 2022-02-07 Rapides Louisiana 22079 31938 522
2188365 2188365 2022-02-06 Rapides Louisiana 22079 31754 521
2185112 2185112 2022-02-05 Rapides Louisiana 22079 31754 521
2181860 2181860 2022-02-04 Rapides Louisiana 22079 31754 521
2178609 2178609 2022-02-03 Rapides Louisiana 22079 31595 516

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 210.958ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette