ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 25009 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 560 ✖
- 0 13
- 2406 11
- 1194 9
- 2403 8
- 2394 7
- 2410 7
- 2411 7
- 1136 6
- 2729 6
- 2730 6
- 2412 5
- 2422 5
- 2427 5
- 2453 5
- 2717 5
- 2725 5
- 2404 4
- 2435 4
- 2441 4
- 2468 4
- 2479 4
- 2494 4
- 2530 4
- 2720 4
- 2831 4
- 3083 4
- 1 3
- 2358 3
- 2380 3
- 2389 3
- 2396 3
- 2399 3
- 2401 3
- 2418 3
- 2447 3
- 2450 3
- 2504 3
- 2513 3
- 2539 3
- 2561 3
- 2580 3
- 2604 3
- 2627 3
- 2662 3
- 2697 3
- 2722 3
- 2736 3
- 2740 3
- 2748 3
- 2758 3
- 2769 3
- 2892 3
- 2951 3
- 3000 3
- 3047 3
- 3111 3
- 3146 3
- 3163 3
- 3 2
- 1104 2
- 1119 2
- 1143 2
- 1177 2
- 1186 2
- 1215 2
- 1253 2
- 1258 2
- 1260 2
- 1261 2
- 1262 2
- 1300 2
- 1307 2
- 1330 2
- 1358 2
- 1362 2
- 1392 2
- 1424 2
- 1436 2
- 1489 2
- 1625 2
- 1698 2
- 1862 2
- 2306 2
- 2317 2
- 2323 2
- 2324 2
- 2328 2
- 2331 2
- 2354 2
- 2362 2
- 2379 2
- 2398 2
- 2405 2
- 2421 2
- 2438 2
- 2511 2
- 2534 2
- 2576 2
- 2712 2
- 2719 2
- 2726 2
- 2731 2
- 2738 2
- 2742 2
- 2747 2
- 4 1
- 5 1
- 7 1
- 13 1
- 18 1
- 19 1
- 24 1
- 26 1
- 28 1
- 31 1
- 37 1
- 52 1
- 61 1
- 80 1
- 92 1
- 102 1
- 114 1
- 126 1
- 141 1
- 160 1
- 179 1
- 194 1
- 210 1
- 225 1
- 245 1
- 271 1
- 292 1
- 319 1
- 336 1
- 350 1
- 359 1
- 383 1
- 425 1
- 448 1
- 460 1
- 484 1
- 499 1
- 512 1
- 527 1
- 561 1
- 578 1
- 601 1
- 625 1
- 644 1
- 669 1
- 678 1
- 704 1
- 725 1
- 751 1
- 766 1
- 776 1
- 790 1
- 797 1
- 817 1
- 831 1
- 842 1
- 848 1
- 859 1
- 863 1
- 870 1
- 878 1
- 895 1
- 906 1
- 909 1
- 925 1
- 968 1
- 971 1
- 979 1
- 986 1
- 990 1
- 998 1
- 1003 1
- 1006 1
- 1016 1
- 1024 1
- 1031 1
- 1035 1
- 1041 1
- 1046 1
- 1051 1
- 1052 1
- 1057 1
- 1063 1
- 1065 1
- 1071 1
- 1076 1
- 1077 1
- 1081 1
- 1083 1
- 1086 1
- 1092 1
- 1096 1
- 1099 1
- 1106 1
- 1111 1
- 1116 1
- 1122 1
- 1126 1
- 1131 1
- 1133 1
- 1137 1
- 1139 1
- 1140 1
- 1146 1
- 1152 1
- 1157 1
- 1159 1
- 1162 1
- 1167 1
- 1169 1
- 1170 1
- 1175 1
- 1182 1
- 1183 1
- 1185 1
- 1190 1
- 1191 1
- 1192 1
- 1193 1
- 1205 1
- 1207 1
- 1210 1
- 1220 1
- 1222 1
- 1226 1
- 1228 1
- 1231 1
- 1234 1
- 1236 1
- 1239 1
- 1240 1
- 1241 1
- 1243 1
- 1249 1
- 1251 1
- 1254 1
- 1256 1
- 1257 1
- 1266 1
- 1268 1
- 1269 1
- 1271 1
- 1273 1
- 1274 1
- 1275 1
- 1280 1
- 1281 1
- 1282 1
- 1283 1
- 1290 1
- 1293 1
- 1294 1
- 1295 1
- 1296 1
- 1303 1
- 1306 1
- 1309 1
- 1311 1
- 1313 1
- 1315 1
- 1318 1
- 1320 1
- 1322 1
- 1326 1
- 1331 1
- 1333 1
- 1336 1
- 1337 1
- 1340 1
- 1341 1
- 1342 1
- 1343 1
- 1348 1
- 1353 1
- 1356 1
- 1361 1
- 1364 1
- 1366 1
- 1369 1
- 1372 1
- 1374 1
- 1382 1
- 1384 1
- 1387 1
- 1390 1
- 1395 1
- 1403 1
- 1407 1
- 1414 1
- 1418 1
- 1429 1
- 1440 1
- 1447 1
- 1452 1
- 1455 1
- 1460 1
- 1467 1
- 1475 1
- 1482 1
- 1485 1
- 1494 1
- 1505 1
- 1510 1
- 1516 1
- 1521 1
- 1532 1
- 1537 1
- 1548 1
- 1560 1
- 1565 1
- 1569 1
- 1578 1
- 1586 1
- 1595 1
- 1599 1
- 1618 1
- 1636 1
- 1654 1
- 1659 1
- 1666 1
- 1683 1
- 1713 1
- 1723 1
- 1734 1
- 1739 1
- 1752 1
- 1763 1
- 1776 1
- 1785 1
- 1797 1
- 1805 1
- 1819 1
- 1827 1
- 1835 1
- 1844 1
- 1853 1
- 1859 1
- 1871 1
- 1878 1
- 1887 1
- 1897 1
- 1908 1
- 1916 1
- 1919 1
- 1929 1
- 1939 1
- 1952 1
- 1964 1
- 1969 1
- 1973 1
- 1980 1
- 1991 1
- 2003 1
- 2009 1
- 2015 1
- 2026 1
- 2033 1
- 2037 1
- 2051 1
- 2058 1
- 2067 1
- 2075 1
- 2078 1
- 2081 1
- 2087 1
- 2096 1
- 2104 1
- 2112 1
- 2121 1
- 2125 1
- 2128 1
- 2130 1
- 2139 1
- 2141 1
- 2149 1
- 2152 1
- 2163 1
- 2166 1
- 2170 1
- 2180 1
- 2186 1
- 2190 1
- 2197 1
- 2202 1
- 2205 1
- 2206 1
- 2211 1
- 2215 1
- 2217 1
- 2220 1
- 2223 1
- 2227 1
- 2230 1
- 2235 1
- 2239 1
- 2244 1
- 2247 1
- 2248 1
- 2253 1
- 2255 1
- 2265 1
- 2271 1
- 2275 1
- 2278 1
- 2282 1
- 2286 1
- 2290 1
- 2295 1
- 2299 1
- 2300 1
- 2313 1
- 2314 1
- 2316 1
- 2318 1
- 2321 1
- 2329 1
- 2334 1
- 2335 1
- 2337 1
- 2340 1
- 2341 1
- 2343 1
- 2344 1
- 2347 1
- 2348 1
- 2349 1
- 2350 1
- 2351 1
- 2352 1
- 2357 1
- 2363 1
- 2365 1
- 2367 1
- 2368 1
- 2369 1
- 2374 1
- 2375 1
- 2378 1
- 2382 1
- 2383 1
- 2385 1
- 2386 1
- 2392 1
- 2393 1
- 2395 1
- 2400 1
- 2402 1
- 2407 1
- 2408 1
- 2413 1
- 2414 1
- 2415 1
- 2416 1
- 2419 1
- 2424 1
- 2426 1
- 2431 1
- 2432 1
- 2434 1
- 2443 1
- 2451 1
- 2452 1
- 2454 1
- 2458 1
- 2462 1
- 2470 1
- 2472 1
- 2475 1
- 2477 1
- 2484 1
- 2488 1
- 2495 1
- 2497 1
- 2499 1
- 2502 1
- 2506 1
- 2510 1
- 2515 1
- 2521 1
- 2523 1
- 2527 1
- 2533 1
- 2542 1
- 2546 1
- 2555 1
- 2558 1
- 2566 1
- 2571 1
- 2589 1
- 2594 1
- 2601 1
- 2603 1
- 2608 1
- 2616 1
- 2618 1
- 2623 1
- 2632 1
- 2642 1
- 2647 1
- 2655 1
- 2673 1
- 2678 1
- 2684 1
- 2690 1
- 2700 1
- 2706 1
- 2711 1
- 2716 1
- 2718 1
- 2723 1
- 2724 1
- 2728 1
- 2734 1
- 2735 1
- 2737 1
- 2739 1
- 2745 1
- 2746 1
- 2749 1
- 2757 1
- 2759 1
- 2780 1
- 2795 1
- 2811 1
- 2817 1
- 2838 1
- 2865 1
- 2875 1
- 2903 1
- 2923 1
- 2932 1
- 2945 1
- 2964 1
- 2976 1
- 2985 1
- 2991 1
- 3009 1
- 3027 1
- 3038 1
- 3041 1
- 3051 1
- 3063 1
- 3069 1
- 3075 1
- 3089 1
- 3105 1
- 3109 1
- 3122 1
- 3135 1
- 3139 1
- 3142 1
- 3149 1
- 3156 1
- 3157 1
- 3160 1
state 1
- Massachusetts 795
fips 1
- 25009 · 795 ✖
county 1
- Essex 795
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1075 | 1075 | 2020-03-10 | Essex | Massachusetts | 25009 | 1 | 0 |
1255 | 1255 | 2020-03-11 | Essex | Massachusetts | 25009 | 1 | 0 |
1473 | 1473 | 2020-03-12 | Essex | Massachusetts | 25009 | 2 | 0 |
1752 | 1752 | 2020-03-13 | Essex | Massachusetts | 25009 | 2 | 0 |
2095 | 2095 | 2020-03-14 | Essex | Massachusetts | 25009 | 5 | 0 |
2496 | 2496 | 2020-03-15 | Essex | Massachusetts | 25009 | 6 | 0 |
2945 | 2945 | 2020-03-16 | Essex | Massachusetts | 25009 | 7 | 0 |
3446 | 3446 | 2020-03-17 | Essex | Massachusetts | 25009 | 8 | 0 |
4028 | 4028 | 2020-03-18 | Essex | Massachusetts | 25009 | 14 | 0 |
4732 | 4732 | 2020-03-19 | Essex | Massachusetts | 25009 | 19 | 0 |
5551 | 5551 | 2020-03-20 | Essex | Massachusetts | 25009 | 29 | 0 |
6510 | 6510 | 2020-03-21 | Essex | Massachusetts | 25009 | 41 | 0 |
7587 | 7587 | 2020-03-22 | Essex | Massachusetts | 25009 | 60 | 0 |
8759 | 8759 | 2020-03-23 | Essex | Massachusetts | 25009 | 73 | 1 |
10048 | 10048 | 2020-03-24 | Essex | Massachusetts | 25009 | 118 | 1 |
11460 | 11460 | 2020-03-25 | Essex | Massachusetts | 25009 | 177 | 1 |
13041 | 13041 | 2020-03-26 | Essex | Massachusetts | 25009 | 247 | 3 |
14749 | 14749 | 2020-03-27 | Essex | Massachusetts | 25009 | 350 | 3 |
16569 | 16569 | 2020-03-28 | Essex | Massachusetts | 25009 | 472 | 4 |
18484 | 18484 | 2020-03-29 | Essex | Massachusetts | 25009 | 570 | 5 |
20500 | 20500 | 2020-03-30 | Essex | Massachusetts | 25009 | 653 | 7 |
22609 | 22609 | 2020-03-31 | Essex | Massachusetts | 25009 | 784 | 13 |
24788 | 24788 | 2020-04-01 | Essex | Massachusetts | 25009 | 885 | 18 |
27040 | 27040 | 2020-04-02 | Essex | Massachusetts | 25009 | 1039 | 19 |
29358 | 29358 | 2020-04-03 | Essex | Massachusetts | 25009 | 1238 | 24 |
31736 | 31736 | 2020-04-04 | Essex | Massachusetts | 25009 | 1400 | 26 |
34161 | 34161 | 2020-04-05 | Essex | Massachusetts | 25009 | 1506 | 28 |
36620 | 36620 | 2020-04-06 | Essex | Massachusetts | 25009 | 1653 | 31 |
39128 | 39128 | 2020-04-07 | Essex | Massachusetts | 25009 | 1841 | 37 |
41680 | 41680 | 2020-04-08 | Essex | Massachusetts | 25009 | 2103 | 52 |
44256 | 44256 | 2020-04-09 | Essex | Massachusetts | 25009 | 2336 | 61 |
46864 | 46864 | 2020-04-10 | Essex | Massachusetts | 25009 | 2670 | 80 |
49506 | 49506 | 2020-04-11 | Essex | Massachusetts | 25009 | 2896 | 92 |
52176 | 52176 | 2020-04-12 | Essex | Massachusetts | 25009 | 3170 | 102 |
54857 | 54857 | 2020-04-13 | Essex | Massachusetts | 25009 | 3413 | 114 |
57555 | 57555 | 2020-04-14 | Essex | Massachusetts | 25009 | 3594 | 126 |
60264 | 60264 | 2020-04-15 | Essex | Massachusetts | 25009 | 3894 | 141 |
62985 | 62985 | 2020-04-16 | Essex | Massachusetts | 25009 | 4245 | 160 |
65723 | 65723 | 2020-04-17 | Essex | Massachusetts | 25009 | 4584 | 179 |
68473 | 68473 | 2020-04-18 | Essex | Massachusetts | 25009 | 4914 | 194 |
71237 | 71237 | 2020-04-19 | Essex | Massachusetts | 25009 | 5153 | 210 |
74009 | 74009 | 2020-04-20 | Essex | Massachusetts | 25009 | 5296 | 225 |
76789 | 76789 | 2020-04-21 | Essex | Massachusetts | 25009 | 5521 | 245 |
79575 | 79575 | 2020-04-22 | Essex | Massachusetts | 25009 | 5783 | 271 |
82370 | 82370 | 2020-04-23 | Essex | Massachusetts | 25009 | 6219 | 292 |
85174 | 85174 | 2020-04-24 | Essex | Massachusetts | 25009 | 6841 | 319 |
87984 | 87984 | 2020-04-25 | Essex | Massachusetts | 25009 | 7212 | 336 |
90800 | 90800 | 2020-04-26 | Essex | Massachusetts | 25009 | 7489 | 350 |
93621 | 93621 | 2020-04-27 | Essex | Massachusetts | 25009 | 7708 | 359 |
96456 | 96456 | 2020-04-28 | Essex | Massachusetts | 25009 | 7972 | 383 |
99302 | 99302 | 2020-04-29 | Essex | Massachusetts | 25009 | 8380 | 425 |
102154 | 102154 | 2020-04-30 | Essex | Massachusetts | 25009 | 8673 | 448 |
105014 | 105014 | 2020-05-01 | Essex | Massachusetts | 25009 | 9028 | 460 |
107878 | 107878 | 2020-05-02 | Essex | Massachusetts | 25009 | 9362 | 484 |
110750 | 110750 | 2020-05-03 | Essex | Massachusetts | 25009 | 9542 | 499 |
113628 | 113628 | 2020-05-04 | Essex | Massachusetts | 25009 | 9773 | 512 |
116509 | 116509 | 2020-05-05 | Essex | Massachusetts | 25009 | 9979 | 527 |
119470 | 119470 | 2020-05-06 | Essex | Massachusetts | 25009 | 10344 | 561 |
122442 | 122442 | 2020-05-07 | Essex | Massachusetts | 25009 | 10610 | 578 |
125424 | 125424 | 2020-05-08 | Essex | Massachusetts | 25009 | 10995 | 601 |
128411 | 128411 | 2020-05-09 | Essex | Massachusetts | 25009 | 11211 | 625 |
131401 | 131401 | 2020-05-10 | Essex | Massachusetts | 25009 | 11353 | 644 |
134392 | 134392 | 2020-05-11 | Essex | Massachusetts | 25009 | 11432 | 669 |
137382 | 137382 | 2020-05-12 | Essex | Massachusetts | 25009 | 11572 | 678 |
140376 | 140376 | 2020-05-13 | Essex | Massachusetts | 25009 | 11703 | 704 |
143371 | 143371 | 2020-05-14 | Essex | Massachusetts | 25009 | 11950 | 725 |
146371 | 146371 | 2020-05-15 | Essex | Massachusetts | 25009 | 12131 | 751 |
149376 | 149376 | 2020-05-16 | Essex | Massachusetts | 25009 | 12314 | 766 |
152387 | 152387 | 2020-05-17 | Essex | Massachusetts | 25009 | 12462 | 776 |
155401 | 155401 | 2020-05-18 | Essex | Massachusetts | 25009 | 12587 | 790 |
158419 | 158419 | 2020-05-19 | Essex | Massachusetts | 25009 | 12748 | 797 |
161445 | 161445 | 2020-05-20 | Essex | Massachusetts | 25009 | 12920 | 817 |
164474 | 164474 | 2020-05-21 | Essex | Massachusetts | 25009 | 13063 | 831 |
167510 | 167510 | 2020-05-22 | Essex | Massachusetts | 25009 | 13221 | 842 |
170547 | 170547 | 2020-05-23 | Essex | Massachusetts | 25009 | 13334 | 848 |
173589 | 173589 | 2020-05-24 | Essex | Massachusetts | 25009 | 13457 | 859 |
176632 | 176632 | 2020-05-25 | Essex | Massachusetts | 25009 | 13575 | 863 |
179676 | 179676 | 2020-05-26 | Essex | Massachusetts | 25009 | 13670 | 870 |
182722 | 182722 | 2020-05-27 | Essex | Massachusetts | 25009 | 13778 | 878 |
185777 | 185777 | 2020-05-28 | Essex | Massachusetts | 25009 | 13899 | 895 |
188835 | 188835 | 2020-05-29 | Essex | Massachusetts | 25009 | 13994 | 906 |
191899 | 191899 | 2020-05-30 | Essex | Massachusetts | 25009 | 14099 | 909 |
194967 | 194967 | 2020-05-31 | Essex | Massachusetts | 25009 | 14225 | 925 |
198038 | 198038 | 2020-06-01 | Essex | Massachusetts | 25009 | 14721 | 968 |
201110 | 201110 | 2020-06-02 | Essex | Massachusetts | 25009 | 14795 | 971 |
204187 | 204187 | 2020-06-03 | Essex | Massachusetts | 25009 | 14857 | 979 |
207268 | 207268 | 2020-06-04 | Essex | Massachusetts | 25009 | 14969 | 986 |
210349 | 210349 | 2020-06-05 | Essex | Massachusetts | 25009 | 15064 | 990 |
213433 | 213433 | 2020-06-06 | Essex | Massachusetts | 25009 | 15170 | 998 |
216521 | 216521 | 2020-06-07 | Essex | Massachusetts | 25009 | 15217 | 1003 |
219613 | 219613 | 2020-06-08 | Essex | Massachusetts | 25009 | 15236 | 1006 |
222708 | 222708 | 2020-06-09 | Essex | Massachusetts | 25009 | 15271 | 1016 |
225804 | 225804 | 2020-06-10 | Essex | Massachusetts | 25009 | 15365 | 1024 |
228906 | 228906 | 2020-06-11 | Essex | Massachusetts | 25009 | 15465 | 1031 |
232010 | 232010 | 2020-06-12 | Essex | Massachusetts | 25009 | 15518 | 1035 |
235115 | 235115 | 2020-06-13 | Essex | Massachusetts | 25009 | 15573 | 1041 |
238222 | 238222 | 2020-06-14 | Essex | Massachusetts | 25009 | 15604 | 1046 |
241331 | 241331 | 2020-06-15 | Essex | Massachusetts | 25009 | 15627 | 1051 |
244442 | 244442 | 2020-06-16 | Essex | Massachusetts | 25009 | 15667 | 1052 |
247555 | 247555 | 2020-06-17 | Essex | Massachusetts | 25009 | 15703 | 1057 |
Advanced export
JSON shape: default, array, newline-delimited
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);