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

788 rows where county = "Rensselaer", fips = 36083 and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 788 ✖

fips 1

  • 36083 · 788 ✖

county 1

  • Rensselaer · 788 ✖
Link rowid date ▲ county state fips cases deaths
2501466 2501466 2022-05-13 Rensselaer New York 36083 33850 259
2498208 2498208 2022-05-12 Rensselaer New York 36083 33850 257
2494950 2494950 2022-05-11 Rensselaer New York 36083 33730 257
2491692 2491692 2022-05-10 Rensselaer New York 36083 33625 256
2488434 2488434 2022-05-09 Rensselaer New York 36083 33567 256
2485177 2485177 2022-05-08 Rensselaer New York 36083 33522 256
2481919 2481919 2022-05-07 Rensselaer New York 36083 33414 256
2478661 2478661 2022-05-06 Rensselaer New York 36083 33325 256
2475403 2475403 2022-05-05 Rensselaer New York 36083 33241 256
2472146 2472146 2022-05-04 Rensselaer New York 36083 33134 255
2468890 2468890 2022-05-03 Rensselaer New York 36083 33059 254
2465634 2465634 2022-05-02 Rensselaer New York 36083 33010 254
2462379 2462379 2022-05-01 Rensselaer New York 36083 32971 253
2459123 2459123 2022-04-30 Rensselaer New York 36083 32822 252
2455867 2455867 2022-04-29 Rensselaer New York 36083 32774 252
2452611 2452611 2022-04-28 Rensselaer New York 36083 32679 252
2449355 2449355 2022-04-27 Rensselaer New York 36083 32574 251
2446098 2446098 2022-04-26 Rensselaer New York 36083 32509 251
2442843 2442843 2022-04-25 Rensselaer New York 36083 32463 251
2439587 2439587 2022-04-24 Rensselaer New York 36083 32417 251
2436331 2436331 2022-04-23 Rensselaer New York 36083 32316 251
2433075 2433075 2022-04-22 Rensselaer New York 36083 32255 251
2429819 2429819 2022-04-21 Rensselaer New York 36083 32184 250
2426563 2426563 2022-04-20 Rensselaer New York 36083 32105 249
2423307 2423307 2022-04-19 Rensselaer New York 36083 32062 249
2420050 2420050 2022-04-18 Rensselaer New York 36083 32026 249
2416795 2416795 2022-04-17 Rensselaer New York 36083 32000 249
2413539 2413539 2022-04-16 Rensselaer New York 36083 31883 249
2410283 2410283 2022-04-15 Rensselaer New York 36083 31836 249
2407027 2407027 2022-04-14 Rensselaer New York 36083 31779 249
2403771 2403771 2022-04-13 Rensselaer New York 36083 31740 249
2400516 2400516 2022-04-12 Rensselaer New York 36083 31704 248
2397261 2397261 2022-04-11 Rensselaer New York 36083 31674 248
2394006 2394006 2022-04-10 Rensselaer New York 36083 31650 248
2390750 2390750 2022-04-09 Rensselaer New York 36083 31559 248
2387494 2387494 2022-04-08 Rensselaer New York 36083 31526 248
2384239 2384239 2022-04-07 Rensselaer New York 36083 31492 248
2380984 2380984 2022-04-06 Rensselaer New York 36083 31457 248
2377729 2377729 2022-04-05 Rensselaer New York 36083 31420 248
2374476 2374476 2022-04-04 Rensselaer New York 36083 31408 248
2371224 2371224 2022-04-03 Rensselaer New York 36083 31395 248
2367971 2367971 2022-04-02 Rensselaer New York 36083 31345 248
2364718 2364718 2022-04-01 Rensselaer New York 36083 31313 248
2361464 2361464 2022-03-31 Rensselaer New York 36083 31291 248
2358210 2358210 2022-03-30 Rensselaer New York 36083 31274 248
2354956 2354956 2022-03-29 Rensselaer New York 36083 31230 248
2351703 2351703 2022-03-28 Rensselaer New York 36083 31219 248
2348451 2348451 2022-03-27 Rensselaer New York 36083 31210 248
2345198 2345198 2022-03-26 Rensselaer New York 36083 31201 247
2341945 2341945 2022-03-25 Rensselaer New York 36083 31177 247
2338692 2338692 2022-03-24 Rensselaer New York 36083 31155 247
2335438 2335438 2022-03-23 Rensselaer New York 36083 31145 247
2332184 2332184 2022-03-22 Rensselaer New York 36083 31130 247
2328931 2328931 2022-03-21 Rensselaer New York 36083 31124 247
2325679 2325679 2022-03-20 Rensselaer New York 36083 31115 247
2322426 2322426 2022-03-19 Rensselaer New York 36083 31093 247
2319172 2319172 2022-03-18 Rensselaer New York 36083 31079 247
2315918 2315918 2022-03-17 Rensselaer New York 36083 31072 247
2312665 2312665 2022-03-16 Rensselaer New York 36083 31060 246
2309412 2309412 2022-03-15 Rensselaer New York 36083 31047 245
2306159 2306159 2022-03-14 Rensselaer New York 36083 31038 245
2302908 2302908 2022-03-13 Rensselaer New York 36083 31035 245
2299656 2299656 2022-03-12 Rensselaer New York 36083 31026 245
2296404 2296404 2022-03-11 Rensselaer New York 36083 31008 245
2293152 2293152 2022-03-10 Rensselaer New York 36083 30989 245
2289900 2289900 2022-03-09 Rensselaer New York 36083 30977 245
2286648 2286648 2022-03-08 Rensselaer New York 36083 30968 245
2283396 2283396 2022-03-07 Rensselaer New York 36083 30960 245
2280144 2280144 2022-03-06 Rensselaer New York 36083 30946 245
2276891 2276891 2022-03-05 Rensselaer New York 36083 30904 244
2273638 2273638 2022-03-04 Rensselaer New York 36083 30875 244
2270385 2270385 2022-03-03 Rensselaer New York 36083 30875 244
2267133 2267133 2022-03-02 Rensselaer New York 36083 30851 244
2263881 2263881 2022-03-01 Rensselaer New York 36083 30822 244
2260630 2260630 2022-02-28 Rensselaer New York 36083 30812 244
2257379 2257379 2022-02-27 Rensselaer New York 36083 30802 243
2254128 2254128 2022-02-26 Rensselaer New York 36083 30789 243
2250877 2250877 2022-02-25 Rensselaer New York 36083 30725 243
2247626 2247626 2022-02-24 Rensselaer New York 36083 30703 243
2244375 2244375 2022-02-23 Rensselaer New York 36083 30670 243
2241124 2241124 2022-02-22 Rensselaer New York 36083 30652 243
2237873 2237873 2022-02-21 Rensselaer New York 36083 30637 243
2234622 2234622 2022-02-20 Rensselaer New York 36083 30623 242
2231371 2231371 2022-02-19 Rensselaer New York 36083 30601 242
2228120 2228120 2022-02-18 Rensselaer New York 36083 30506 242
2224869 2224869 2022-02-17 Rensselaer New York 36083 30476 242
2221618 2221618 2022-02-16 Rensselaer New York 36083 30439 242
2218367 2218367 2022-02-15 Rensselaer New York 36083 30406 241
2215116 2215116 2022-02-14 Rensselaer New York 36083 30375 241
2211865 2211865 2022-02-13 Rensselaer New York 36083 30352 241
2208612 2208612 2022-02-12 Rensselaer New York 36083 30275 240
2205359 2205359 2022-02-11 Rensselaer New York 36083 30250 240
2202106 2202106 2022-02-10 Rensselaer New York 36083 30206 240
2198852 2198852 2022-02-09 Rensselaer New York 36083 30148 240
2195598 2195598 2022-02-08 Rensselaer New York 36083 30099 239
2192344 2192344 2022-02-07 Rensselaer New York 36083 30058 239
2189090 2189090 2022-02-06 Rensselaer New York 36083 30021 239
2185837 2185837 2022-02-05 Rensselaer New York 36083 29900 239
2182585 2182585 2022-02-04 Rensselaer New York 36083 29820 237
2179333 2179333 2022-02-03 Rensselaer New York 36083 29695 237

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