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

794 rows where county = "Monroe" and fips = 36055 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

  • 36055 · 794 ✖

county 1

  • Monroe · 794 ✖
Link rowid date ▲ county state fips cases deaths
2501453 2501453 2022-05-13 Monroe New York 36055 163464 1587
2498195 2498195 2022-05-12 Monroe New York 36055 163464 1586
2494937 2494937 2022-05-11 Monroe New York 36055 163022 1583
2491679 2491679 2022-05-10 Monroe New York 36055 162669 1582
2488421 2488421 2022-05-09 Monroe New York 36055 162439 1581
2485164 2485164 2022-05-08 Monroe New York 36055 162211 1578
2481906 2481906 2022-05-07 Monroe New York 36055 161897 1578
2478648 2478648 2022-05-06 Monroe New York 36055 161514 1575
2475390 2475390 2022-05-05 Monroe New York 36055 161152 1574
2472133 2472133 2022-05-04 Monroe New York 36055 160741 1573
2468877 2468877 2022-05-03 Monroe New York 36055 160324 1573
2465621 2465621 2022-05-02 Monroe New York 36055 160134 1572
2462366 2462366 2022-05-01 Monroe New York 36055 159935 1570
2459110 2459110 2022-04-30 Monroe New York 36055 159618 1570
2455854 2455854 2022-04-29 Monroe New York 36055 159255 1568
2452598 2452598 2022-04-28 Monroe New York 36055 158863 1566
2449342 2449342 2022-04-27 Monroe New York 36055 158406 1565
2446085 2446085 2022-04-26 Monroe New York 36055 157951 1564
2442830 2442830 2022-04-25 Monroe New York 36055 157754 1562
2439574 2439574 2022-04-24 Monroe New York 36055 157475 1560
2436318 2436318 2022-04-23 Monroe New York 36055 156949 1560
2433062 2433062 2022-04-22 Monroe New York 36055 156718 1560
2429806 2429806 2022-04-21 Monroe New York 36055 156318 1559
2426550 2426550 2022-04-20 Monroe New York 36055 155909 1559
2423294 2423294 2022-04-19 Monroe New York 36055 155582 1559
2420037 2420037 2022-04-18 Monroe New York 36055 155397 1556
2416782 2416782 2022-04-17 Monroe New York 36055 155165 1556
2413526 2413526 2022-04-16 Monroe New York 36055 154860 1556
2410270 2410270 2022-04-15 Monroe New York 36055 154523 1556
2407014 2407014 2022-04-14 Monroe New York 36055 154173 1556
2403758 2403758 2022-04-13 Monroe New York 36055 153835 1555
2400503 2400503 2022-04-12 Monroe New York 36055 153495 1555
2397248 2397248 2022-04-11 Monroe New York 36055 153352 1555
2393993 2393993 2022-04-10 Monroe New York 36055 153170 1553
2390737 2390737 2022-04-09 Monroe New York 36055 152956 1552
2387481 2387481 2022-04-08 Monroe New York 36055 152696 1551
2384226 2384226 2022-04-07 Monroe New York 36055 152442 1551
2380971 2380971 2022-04-06 Monroe New York 36055 152170 1550
2377716 2377716 2022-04-05 Monroe New York 36055 151963 1550
2374463 2374463 2022-04-04 Monroe New York 36055 151867 1550
2371211 2371211 2022-04-03 Monroe New York 36055 151734 1550
2367958 2367958 2022-04-02 Monroe New York 36055 151602 1550
2364705 2364705 2022-04-01 Monroe New York 36055 151456 1550
2361451 2361451 2022-03-31 Monroe New York 36055 151274 1550
2358197 2358197 2022-03-30 Monroe New York 36055 151119 1549
2354943 2354943 2022-03-29 Monroe New York 36055 150972 1548
2351690 2351690 2022-03-28 Monroe New York 36055 150904 1548
2348438 2348438 2022-03-27 Monroe New York 36055 150831 1548
2345185 2345185 2022-03-26 Monroe New York 36055 150735 1548
2341932 2341932 2022-03-25 Monroe New York 36055 150624 1547
2338679 2338679 2022-03-24 Monroe New York 36055 150526 1547
2335425 2335425 2022-03-23 Monroe New York 36055 150422 1546
2332171 2332171 2022-03-22 Monroe New York 36055 150279 1546
2328918 2328918 2022-03-21 Monroe New York 36055 150252 1546
2325666 2325666 2022-03-20 Monroe New York 36055 150214 1546
2322413 2322413 2022-03-19 Monroe New York 36055 150175 1546
2319159 2319159 2022-03-18 Monroe New York 36055 150123 1545
2315905 2315905 2022-03-17 Monroe New York 36055 150059 1544
2312652 2312652 2022-03-16 Monroe New York 36055 149979 1544
2309399 2309399 2022-03-15 Monroe New York 36055 149918 1543
2306146 2306146 2022-03-14 Monroe New York 36055 149891 1543
2302895 2302895 2022-03-13 Monroe New York 36055 149850 1543
2299643 2299643 2022-03-12 Monroe New York 36055 149801 1543
2296391 2296391 2022-03-11 Monroe New York 36055 149763 1543
2293139 2293139 2022-03-10 Monroe New York 36055 149710 1543
2289887 2289887 2022-03-09 Monroe New York 36055 149661 1543
2286635 2286635 2022-03-08 Monroe New York 36055 149608 1543
2283383 2283383 2022-03-07 Monroe New York 36055 149584 1543
2280131 2280131 2022-03-06 Monroe New York 36055 149561 1543
2276878 2276878 2022-03-05 Monroe New York 36055 149524 1543
2273625 2273625 2022-03-04 Monroe New York 36055 149418 1543
2270372 2270372 2022-03-03 Monroe New York 36055 149418 1543
2267120 2267120 2022-03-02 Monroe New York 36055 149363 1541
2263868 2263868 2022-03-01 Monroe New York 36055 149287 1540
2260617 2260617 2022-02-28 Monroe New York 36055 149252 1539
2257366 2257366 2022-02-27 Monroe New York 36055 149211 1537
2254115 2254115 2022-02-26 Monroe New York 36055 149162 1535
2250864 2250864 2022-02-25 Monroe New York 36055 149102 1533
2247613 2247613 2022-02-24 Monroe New York 36055 149038 1532
2244362 2244362 2022-02-23 Monroe New York 36055 148944 1531
2241111 2241111 2022-02-22 Monroe New York 36055 148885 1530
2237860 2237860 2022-02-21 Monroe New York 36055 148844 1527
2234609 2234609 2022-02-20 Monroe New York 36055 148774 1526
2231358 2231358 2022-02-19 Monroe New York 36055 148685 1526
2228107 2228107 2022-02-18 Monroe New York 36055 148583 1524
2224856 2224856 2022-02-17 Monroe New York 36055 148456 1524
2221605 2221605 2022-02-16 Monroe New York 36055 148317 1521
2218354 2218354 2022-02-15 Monroe New York 36055 148219 1521
2215103 2215103 2022-02-14 Monroe New York 36055 148154 1520
2211852 2211852 2022-02-13 Monroe New York 36055 148072 1519
2208599 2208599 2022-02-12 Monroe New York 36055 147943 1515
2205346 2205346 2022-02-11 Monroe New York 36055 147794 1515
2202093 2202093 2022-02-10 Monroe New York 36055 147613 1510
2198839 2198839 2022-02-09 Monroe New York 36055 147400 1507
2195585 2195585 2022-02-08 Monroe New York 36055 147214 1505
2192331 2192331 2022-02-07 Monroe New York 36055 147112 1503
2189077 2189077 2022-02-06 Monroe New York 36055 146949 1500
2185824 2185824 2022-02-05 Monroe New York 36055 146762 1497
2182572 2182572 2022-02-04 Monroe New York 36055 146549 1493
2179320 2179320 2022-02-03 Monroe New York 36055 146232 1486

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