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

797 rows where fips = 36103 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 · 797 ✖

fips 1

  • 36103 · 797 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501475 2501475 2022-05-13 Suffolk New York 36103 444799 4399
2498217 2498217 2022-05-12 Suffolk New York 36103 444799 4397
2494959 2494959 2022-05-11 Suffolk New York 36103 443819 4397
2491701 2491701 2022-05-10 Suffolk New York 36103 442999 4394
2488443 2488443 2022-05-09 Suffolk New York 36103 442394 4389
2485186 2485186 2022-05-08 Suffolk New York 36103 441860 4389
2481928 2481928 2022-05-07 Suffolk New York 36103 441016 4388
2478670 2478670 2022-05-06 Suffolk New York 36103 440186 4388
2475412 2475412 2022-05-05 Suffolk New York 36103 439320 4387
2472155 2472155 2022-05-04 Suffolk New York 36103 438578 4386
2468899 2468899 2022-05-03 Suffolk New York 36103 437854 4386
2465643 2465643 2022-05-02 Suffolk New York 36103 437440 4385
2462388 2462388 2022-05-01 Suffolk New York 36103 437047 4385
2459132 2459132 2022-04-30 Suffolk New York 36103 436536 4382
2455876 2455876 2022-04-29 Suffolk New York 36103 435968 4380
2452620 2452620 2022-04-28 Suffolk New York 36103 435366 4380
2449364 2449364 2022-04-27 Suffolk New York 36103 434601 4380
2446107 2446107 2022-04-26 Suffolk New York 36103 434072 4379
2442852 2442852 2022-04-25 Suffolk New York 36103 433824 4378
2439596 2439596 2022-04-24 Suffolk New York 36103 433514 4377
2436340 2436340 2022-04-23 Suffolk New York 36103 433103 4375
2433084 2433084 2022-04-22 Suffolk New York 36103 432774 4375
2429828 2429828 2022-04-21 Suffolk New York 36103 432103 4375
2426572 2426572 2022-04-20 Suffolk New York 36103 431734 4374
2423316 2423316 2022-04-19 Suffolk New York 36103 431321 4373
2420059 2420059 2022-04-18 Suffolk New York 36103 430998 4369
2416804 2416804 2022-04-17 Suffolk New York 36103 430671 4369
2413548 2413548 2022-04-16 Suffolk New York 36103 430385 4369
2410292 2410292 2022-04-15 Suffolk New York 36103 429977 4369
2407036 2407036 2022-04-14 Suffolk New York 36103 429501 4369
2403780 2403780 2022-04-13 Suffolk New York 36103 429021 4368
2400525 2400525 2022-04-12 Suffolk New York 36103 428621 4368
2397270 2397270 2022-04-11 Suffolk New York 36103 428448 4368
2394015 2394015 2022-04-10 Suffolk New York 36103 428105 4367
2390759 2390759 2022-04-09 Suffolk New York 36103 427647 4367
2387503 2387503 2022-04-08 Suffolk New York 36103 427403 4367
2384248 2384248 2022-04-07 Suffolk New York 36103 427155 4367
2380993 2380993 2022-04-06 Suffolk New York 36103 426827 4367
2377738 2377738 2022-04-05 Suffolk New York 36103 426649 4367
2374485 2374485 2022-04-04 Suffolk New York 36103 426561 4367
2371233 2371233 2022-04-03 Suffolk New York 36103 426418 4365
2367980 2367980 2022-04-02 Suffolk New York 36103 426256 4364
2364727 2364727 2022-04-01 Suffolk New York 36103 426007 4364
2361473 2361473 2022-03-31 Suffolk New York 36103 425814 4363
2358219 2358219 2022-03-30 Suffolk New York 36103 425609 4363
2354965 2354965 2022-03-29 Suffolk New York 36103 425479 4361
2351712 2351712 2022-03-28 Suffolk New York 36103 425373 4359
2348460 2348460 2022-03-27 Suffolk New York 36103 425268 4359
2345207 2345207 2022-03-26 Suffolk New York 36103 425132 4359
2341954 2341954 2022-03-25 Suffolk New York 36103 424974 4359
2338701 2338701 2022-03-24 Suffolk New York 36103 424819 4358
2335447 2335447 2022-03-23 Suffolk New York 36103 424691 4358
2332193 2332193 2022-03-22 Suffolk New York 36103 424558 4358
2328940 2328940 2022-03-21 Suffolk New York 36103 424512 4358
2325688 2325688 2022-03-20 Suffolk New York 36103 424453 4357
2322435 2322435 2022-03-19 Suffolk New York 36103 424357 4357
2319181 2319181 2022-03-18 Suffolk New York 36103 424214 4357
2315927 2315927 2022-03-17 Suffolk New York 36103 424109 4355
2312674 2312674 2022-03-16 Suffolk New York 36103 424029 4355
2309421 2309421 2022-03-15 Suffolk New York 36103 423929 4355
2306168 2306168 2022-03-14 Suffolk New York 36103 423828 4355
2302917 2302917 2022-03-13 Suffolk New York 36103 423774 4355
2299665 2299665 2022-03-12 Suffolk New York 36103 423673 4353
2296413 2296413 2022-03-11 Suffolk New York 36103 423580 4353
2293161 2293161 2022-03-10 Suffolk New York 36103 423513 4351
2289909 2289909 2022-03-09 Suffolk New York 36103 423368 4349
2286657 2286657 2022-03-08 Suffolk New York 36103 423258 4346
2283405 2283405 2022-03-07 Suffolk New York 36103 423224 4346
2280153 2280153 2022-03-06 Suffolk New York 36103 423166 4344
2276900 2276900 2022-03-05 Suffolk New York 36103 423073 4343
2273647 2273647 2022-03-04 Suffolk New York 36103 422911 4342
2270394 2270394 2022-03-03 Suffolk New York 36103 422911 4342
2267142 2267142 2022-03-02 Suffolk New York 36103 422746 4341
2263890 2263890 2022-03-01 Suffolk New York 36103 422642 4340
2260639 2260639 2022-02-28 Suffolk New York 36103 422575 4338
2257388 2257388 2022-02-27 Suffolk New York 36103 422503 4338
2254137 2254137 2022-02-26 Suffolk New York 36103 422402 4336
2250886 2250886 2022-02-25 Suffolk New York 36103 422288 4335
2247635 2247635 2022-02-24 Suffolk New York 36103 422158 4333
2244384 2244384 2022-02-23 Suffolk New York 36103 422039 4331
2241133 2241133 2022-02-22 Suffolk New York 36103 421863 4328
2237882 2237882 2022-02-21 Suffolk New York 36103 421752 4327
2234631 2234631 2022-02-20 Suffolk New York 36103 421646 4325
2231380 2231380 2022-02-19 Suffolk New York 36103 421494 4321
2228129 2228129 2022-02-18 Suffolk New York 36103 421351 4318
2224878 2224878 2022-02-17 Suffolk New York 36103 421124 4310
2221627 2221627 2022-02-16 Suffolk New York 36103 420923 4304
2218376 2218376 2022-02-15 Suffolk New York 36103 420752 4303
2215125 2215125 2022-02-14 Suffolk New York 36103 420599 4301
2211874 2211874 2022-02-13 Suffolk New York 36103 420424 4301
2208621 2208621 2022-02-12 Suffolk New York 36103 420205 4292
2205368 2205368 2022-02-11 Suffolk New York 36103 419954 4292
2202115 2202115 2022-02-10 Suffolk New York 36103 419658 4288
2198861 2198861 2022-02-09 Suffolk New York 36103 419316 4285
2195607 2195607 2022-02-08 Suffolk New York 36103 419040 4276
2192353 2192353 2022-02-07 Suffolk New York 36103 418796 4267
2189099 2189099 2022-02-06 Suffolk New York 36103 418536 4255
2185846 2185846 2022-02-05 Suffolk New York 36103 418144 4251
2182594 2182594 2022-02-04 Suffolk New York 36103 417634 4245
2179342 2179342 2022-02-03 Suffolk New York 36103 417188 4232

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