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

787 rows where county = "Lee" and fips = 45061 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • South Carolina 787

fips 1

  • 45061 · 787 ✖

county 1

  • Lee · 787 ✖
Link rowid date ▲ county state fips cases deaths
2502029 2502029 2022-05-13 Lee South Carolina 45061 4272 95
2498771 2498771 2022-05-12 Lee South Carolina 45061 4272 95
2495513 2495513 2022-05-11 Lee South Carolina 45061 4272 95
2492255 2492255 2022-05-10 Lee South Carolina 45061 4266 95
2488997 2488997 2022-05-09 Lee South Carolina 45061 4266 95
2485740 2485740 2022-05-08 Lee South Carolina 45061 4266 95
2482482 2482482 2022-05-07 Lee South Carolina 45061 4266 95
2479224 2479224 2022-05-06 Lee South Carolina 45061 4266 95
2475966 2475966 2022-05-05 Lee South Carolina 45061 4266 95
2472709 2472709 2022-05-04 Lee South Carolina 45061 4266 95
2469453 2469453 2022-05-03 Lee South Carolina 45061 4266 95
2466197 2466197 2022-05-02 Lee South Carolina 45061 4254 95
2462942 2462942 2022-05-01 Lee South Carolina 45061 4254 95
2459686 2459686 2022-04-30 Lee South Carolina 45061 4254 95
2456430 2456430 2022-04-29 Lee South Carolina 45061 4254 95
2453174 2453174 2022-04-28 Lee South Carolina 45061 4254 95
2449918 2449918 2022-04-27 Lee South Carolina 45061 4253 95
2446661 2446661 2022-04-26 Lee South Carolina 45061 4253 95
2443406 2443406 2022-04-25 Lee South Carolina 45061 4253 95
2440150 2440150 2022-04-24 Lee South Carolina 45061 4253 95
2436894 2436894 2022-04-23 Lee South Carolina 45061 4253 95
2433638 2433638 2022-04-22 Lee South Carolina 45061 4253 95
2430382 2430382 2022-04-21 Lee South Carolina 45061 4253 95
2427126 2427126 2022-04-20 Lee South Carolina 45061 4253 95
2423870 2423870 2022-04-19 Lee South Carolina 45061 4253 95
2420614 2420614 2022-04-18 Lee South Carolina 45061 4251 94
2417358 2417358 2022-04-17 Lee South Carolina 45061 4251 94
2414102 2414102 2022-04-16 Lee South Carolina 45061 4251 94
2410846 2410846 2022-04-15 Lee South Carolina 45061 4251 94
2407590 2407590 2022-04-14 Lee South Carolina 45061 4251 94
2404334 2404334 2022-04-13 Lee South Carolina 45061 4251 94
2401079 2401079 2022-04-12 Lee South Carolina 45061 4251 94
2397824 2397824 2022-04-11 Lee South Carolina 45061 4249 93
2394569 2394569 2022-04-10 Lee South Carolina 45061 4249 93
2391313 2391313 2022-04-09 Lee South Carolina 45061 4249 93
2388057 2388057 2022-04-08 Lee South Carolina 45061 4249 93
2384802 2384802 2022-04-07 Lee South Carolina 45061 4249 93
2381547 2381547 2022-04-06 Lee South Carolina 45061 4249 93
2378292 2378292 2022-04-05 Lee South Carolina 45061 4249 93
2375038 2375038 2022-04-04 Lee South Carolina 45061 4247 93
2371786 2371786 2022-04-03 Lee South Carolina 45061 4247 93
2368533 2368533 2022-04-02 Lee South Carolina 45061 4247 93
2365280 2365280 2022-04-01 Lee South Carolina 45061 4247 93
2362027 2362027 2022-03-31 Lee South Carolina 45061 4247 93
2358773 2358773 2022-03-30 Lee South Carolina 45061 4247 93
2355519 2355519 2022-03-29 Lee South Carolina 45061 4247 93
2352266 2352266 2022-03-28 Lee South Carolina 45061 4245 93
2349014 2349014 2022-03-27 Lee South Carolina 45061 4245 93
2345761 2345761 2022-03-26 Lee South Carolina 45061 4245 93
2342508 2342508 2022-03-25 Lee South Carolina 45061 4245 93
2339255 2339255 2022-03-24 Lee South Carolina 45061 4245 93
2336001 2336001 2022-03-23 Lee South Carolina 45061 4245 93
2332747 2332747 2022-03-22 Lee South Carolina 45061 4245 93
2329494 2329494 2022-03-21 Lee South Carolina 45061 4241 93
2326242 2326242 2022-03-20 Lee South Carolina 45061 4241 93
2322989 2322989 2022-03-19 Lee South Carolina 45061 4241 93
2319735 2319735 2022-03-18 Lee South Carolina 45061 4241 93
2316481 2316481 2022-03-17 Lee South Carolina 45061 4241 93
2313228 2313228 2022-03-16 Lee South Carolina 45061 4241 93
2309975 2309975 2022-03-15 Lee South Carolina 45061 4241 93
2306722 2306722 2022-03-14 Lee South Carolina 45061 4234 93
2303471 2303471 2022-03-13 Lee South Carolina 45061 4234 93
2300219 2300219 2022-03-12 Lee South Carolina 45061 4234 93
2296967 2296967 2022-03-11 Lee South Carolina 45061 4234 93
2293715 2293715 2022-03-10 Lee South Carolina 45061 4233 93
2290463 2290463 2022-03-09 Lee South Carolina 45061 4235 92
2287211 2287211 2022-03-08 Lee South Carolina 45061 4235 92
2283959 2283959 2022-03-07 Lee South Carolina 45061 4234 92
2280707 2280707 2022-03-06 Lee South Carolina 45061 4228 91
2277454 2277454 2022-03-05 Lee South Carolina 45061 4228 91
2274201 2274201 2022-03-04 Lee South Carolina 45061 4228 91
2270948 2270948 2022-03-03 Lee South Carolina 45061 4213 91
2267696 2267696 2022-03-02 Lee South Carolina 45061 4211 91
2264443 2264443 2022-03-01 Lee South Carolina 45061 4210 91
2261193 2261193 2022-02-28 Lee South Carolina 45061 4208 90
2257942 2257942 2022-02-27 Lee South Carolina 45061 4202 90
2254691 2254691 2022-02-26 Lee South Carolina 45061 4202 90
2251440 2251440 2022-02-25 Lee South Carolina 45061 4202 90
2248189 2248189 2022-02-24 Lee South Carolina 45061 4200 90
2244938 2244938 2022-02-23 Lee South Carolina 45061 4198 90
2241687 2241687 2022-02-22 Lee South Carolina 45061 4197 90
2238436 2238436 2022-02-21 Lee South Carolina 45061 4188 90
2235185 2235185 2022-02-20 Lee South Carolina 45061 4188 90
2231934 2231934 2022-02-19 Lee South Carolina 45061 4188 90
2228683 2228683 2022-02-18 Lee South Carolina 45061 4188 90
2225432 2225432 2022-02-17 Lee South Carolina 45061 4185 90
2222181 2222181 2022-02-16 Lee South Carolina 45061 4177 90
2218930 2218930 2022-02-15 Lee South Carolina 45061 4177 89
2215679 2215679 2022-02-14 Lee South Carolina 45061 4179 89
2212428 2212428 2022-02-13 Lee South Carolina 45061 4160 89
2209175 2209175 2022-02-12 Lee South Carolina 45061 4160 89
2205922 2205922 2022-02-11 Lee South Carolina 45061 4160 89
2202669 2202669 2022-02-10 Lee South Carolina 45061 4160 89
2199415 2199415 2022-02-09 Lee South Carolina 45061 4159 88
2196161 2196161 2022-02-08 Lee South Carolina 45061 4155 88
2192907 2192907 2022-02-07 Lee South Carolina 45061 4146 88
2189653 2189653 2022-02-06 Lee South Carolina 45061 4110 88
2186400 2186400 2022-02-05 Lee South Carolina 45061 4110 88
2183148 2183148 2022-02-04 Lee South Carolina 45061 4110 88
2179896 2179896 2022-02-03 Lee South Carolina 45061 4097 88

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