ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,533 rows where county = "Alexander" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500178 | 2500178 | 2022-05-13 | Alexander | Illinois | 17003 | 1288 | 15 |
2501487 | 2501487 | 2022-05-13 | Alexander | North Carolina | 37003 | 10479 | 139 |
2496920 | 2496920 | 2022-05-12 | Alexander | Illinois | 17003 | 1288 | 15 |
2498229 | 2498229 | 2022-05-12 | Alexander | North Carolina | 37003 | 10479 | 139 |
2493662 | 2493662 | 2022-05-11 | Alexander | Illinois | 17003 | 1288 | 15 |
2494971 | 2494971 | 2022-05-11 | Alexander | North Carolina | 37003 | 10479 | 139 |
2490404 | 2490404 | 2022-05-10 | Alexander | Illinois | 17003 | 1287 | 15 |
2491713 | 2491713 | 2022-05-10 | Alexander | North Carolina | 37003 | 10465 | 139 |
2487147 | 2487147 | 2022-05-09 | Alexander | Illinois | 17003 | 1287 | 15 |
2488455 | 2488455 | 2022-05-09 | Alexander | North Carolina | 37003 | 10465 | 139 |
2483889 | 2483889 | 2022-05-08 | Alexander | Illinois | 17003 | 1287 | 15 |
2485198 | 2485198 | 2022-05-08 | Alexander | North Carolina | 37003 | 10465 | 139 |
2480631 | 2480631 | 2022-05-07 | Alexander | Illinois | 17003 | 1287 | 15 |
2481940 | 2481940 | 2022-05-07 | Alexander | North Carolina | 37003 | 10465 | 139 |
2477373 | 2477373 | 2022-05-06 | Alexander | Illinois | 17003 | 1287 | 15 |
2478682 | 2478682 | 2022-05-06 | Alexander | North Carolina | 37003 | 10465 | 139 |
2474115 | 2474115 | 2022-05-05 | Alexander | Illinois | 17003 | 1287 | 15 |
2475424 | 2475424 | 2022-05-05 | Alexander | North Carolina | 37003 | 10465 | 139 |
2470858 | 2470858 | 2022-05-04 | Alexander | Illinois | 17003 | 1288 | 15 |
2472167 | 2472167 | 2022-05-04 | Alexander | North Carolina | 37003 | 10465 | 139 |
2467602 | 2467602 | 2022-05-03 | Alexander | Illinois | 17003 | 1287 | 15 |
2468911 | 2468911 | 2022-05-03 | Alexander | North Carolina | 37003 | 10432 | 133 |
2464347 | 2464347 | 2022-05-02 | Alexander | Illinois | 17003 | 1286 | 15 |
2465655 | 2465655 | 2022-05-02 | Alexander | North Carolina | 37003 | 10432 | 133 |
2461091 | 2461091 | 2022-05-01 | Alexander | Illinois | 17003 | 1286 | 15 |
2462400 | 2462400 | 2022-05-01 | Alexander | North Carolina | 37003 | 10432 | 133 |
2457835 | 2457835 | 2022-04-30 | Alexander | Illinois | 17003 | 1286 | 15 |
2459144 | 2459144 | 2022-04-30 | Alexander | North Carolina | 37003 | 10432 | 133 |
2454579 | 2454579 | 2022-04-29 | Alexander | Illinois | 17003 | 1286 | 15 |
2455888 | 2455888 | 2022-04-29 | Alexander | North Carolina | 37003 | 10432 | 133 |
2451323 | 2451323 | 2022-04-28 | Alexander | Illinois | 17003 | 1286 | 15 |
2452632 | 2452632 | 2022-04-28 | Alexander | North Carolina | 37003 | 10432 | 133 |
2448067 | 2448067 | 2022-04-27 | Alexander | Illinois | 17003 | 1286 | 15 |
2449376 | 2449376 | 2022-04-27 | Alexander | North Carolina | 37003 | 10432 | 133 |
2444811 | 2444811 | 2022-04-26 | Alexander | Illinois | 17003 | 1286 | 15 |
2446119 | 2446119 | 2022-04-26 | Alexander | North Carolina | 37003 | 10419 | 133 |
2441555 | 2441555 | 2022-04-25 | Alexander | Illinois | 17003 | 1287 | 15 |
2442864 | 2442864 | 2022-04-25 | Alexander | North Carolina | 37003 | 10419 | 133 |
2438299 | 2438299 | 2022-04-24 | Alexander | Illinois | 17003 | 1286 | 15 |
2439608 | 2439608 | 2022-04-24 | Alexander | North Carolina | 37003 | 10419 | 133 |
2435043 | 2435043 | 2022-04-23 | Alexander | Illinois | 17003 | 1286 | 15 |
2436352 | 2436352 | 2022-04-23 | Alexander | North Carolina | 37003 | 10419 | 133 |
2431787 | 2431787 | 2022-04-22 | Alexander | Illinois | 17003 | 1286 | 15 |
2433096 | 2433096 | 2022-04-22 | Alexander | North Carolina | 37003 | 10419 | 133 |
2428531 | 2428531 | 2022-04-21 | Alexander | Illinois | 17003 | 1285 | 15 |
2429840 | 2429840 | 2022-04-21 | Alexander | North Carolina | 37003 | 10419 | 133 |
2425275 | 2425275 | 2022-04-20 | Alexander | Illinois | 17003 | 1284 | 15 |
2426584 | 2426584 | 2022-04-20 | Alexander | North Carolina | 37003 | 10419 | 133 |
2422019 | 2422019 | 2022-04-19 | Alexander | Illinois | 17003 | 1284 | 15 |
2423328 | 2423328 | 2022-04-19 | Alexander | North Carolina | 37003 | 10430 | 133 |
2418763 | 2418763 | 2022-04-18 | Alexander | Illinois | 17003 | 1284 | 15 |
2420071 | 2420071 | 2022-04-18 | Alexander | North Carolina | 37003 | 10430 | 133 |
2415507 | 2415507 | 2022-04-17 | Alexander | Illinois | 17003 | 1284 | 15 |
2416816 | 2416816 | 2022-04-17 | Alexander | North Carolina | 37003 | 10430 | 133 |
2412251 | 2412251 | 2022-04-16 | Alexander | Illinois | 17003 | 1284 | 15 |
2413560 | 2413560 | 2022-04-16 | Alexander | North Carolina | 37003 | 10430 | 133 |
2408995 | 2408995 | 2022-04-15 | Alexander | Illinois | 17003 | 1284 | 15 |
2410304 | 2410304 | 2022-04-15 | Alexander | North Carolina | 37003 | 10430 | 133 |
2405739 | 2405739 | 2022-04-14 | Alexander | Illinois | 17003 | 1284 | 15 |
2407048 | 2407048 | 2022-04-14 | Alexander | North Carolina | 37003 | 10430 | 133 |
2402484 | 2402484 | 2022-04-13 | Alexander | Illinois | 17003 | 1283 | 15 |
2403792 | 2403792 | 2022-04-13 | Alexander | North Carolina | 37003 | 10430 | 133 |
2399229 | 2399229 | 2022-04-12 | Alexander | Illinois | 17003 | 1283 | 15 |
2400537 | 2400537 | 2022-04-12 | Alexander | North Carolina | 37003 | 10426 | 133 |
2395974 | 2395974 | 2022-04-11 | Alexander | Illinois | 17003 | 1281 | 15 |
2397282 | 2397282 | 2022-04-11 | Alexander | North Carolina | 37003 | 10426 | 133 |
2392718 | 2392718 | 2022-04-10 | Alexander | Illinois | 17003 | 1281 | 15 |
2394027 | 2394027 | 2022-04-10 | Alexander | North Carolina | 37003 | 10426 | 133 |
2389462 | 2389462 | 2022-04-09 | Alexander | Illinois | 17003 | 1281 | 15 |
2390771 | 2390771 | 2022-04-09 | Alexander | North Carolina | 37003 | 10426 | 133 |
2386207 | 2386207 | 2022-04-08 | Alexander | Illinois | 17003 | 1281 | 15 |
2387515 | 2387515 | 2022-04-08 | Alexander | North Carolina | 37003 | 10426 | 133 |
2382952 | 2382952 | 2022-04-07 | Alexander | Illinois | 17003 | 1280 | 15 |
2384260 | 2384260 | 2022-04-07 | Alexander | North Carolina | 37003 | 10426 | 133 |
2379697 | 2379697 | 2022-04-06 | Alexander | Illinois | 17003 | 1280 | 15 |
2381005 | 2381005 | 2022-04-06 | Alexander | North Carolina | 37003 | 10426 | 133 |
2376443 | 2376443 | 2022-04-05 | Alexander | Illinois | 17003 | 1280 | 15 |
2377750 | 2377750 | 2022-04-05 | Alexander | North Carolina | 37003 | 10423 | 133 |
2373191 | 2373191 | 2022-04-04 | Alexander | Illinois | 17003 | 1278 | 15 |
2374497 | 2374497 | 2022-04-04 | Alexander | North Carolina | 37003 | 10423 | 133 |
2369938 | 2369938 | 2022-04-03 | Alexander | Illinois | 17003 | 1276 | 15 |
2371245 | 2371245 | 2022-04-03 | Alexander | North Carolina | 37003 | 10422 | 133 |
2366685 | 2366685 | 2022-04-02 | Alexander | Illinois | 17003 | 1276 | 15 |
2367992 | 2367992 | 2022-04-02 | Alexander | North Carolina | 37003 | 10422 | 133 |
2363432 | 2363432 | 2022-04-01 | Alexander | Illinois | 17003 | 1276 | 15 |
2364739 | 2364739 | 2022-04-01 | Alexander | North Carolina | 37003 | 10422 | 133 |
2360178 | 2360178 | 2022-03-31 | Alexander | Illinois | 17003 | 1277 | 15 |
2361485 | 2361485 | 2022-03-31 | Alexander | North Carolina | 37003 | 10422 | 133 |
2356924 | 2356924 | 2022-03-30 | Alexander | Illinois | 17003 | 1276 | 15 |
2358231 | 2358231 | 2022-03-30 | Alexander | North Carolina | 37003 | 10420 | 133 |
2353671 | 2353671 | 2022-03-29 | Alexander | Illinois | 17003 | 1276 | 15 |
2354977 | 2354977 | 2022-03-29 | Alexander | North Carolina | 37003 | 10420 | 133 |
2350419 | 2350419 | 2022-03-28 | Alexander | Illinois | 17003 | 1275 | 15 |
2351724 | 2351724 | 2022-03-28 | Alexander | North Carolina | 37003 | 10420 | 133 |
2347166 | 2347166 | 2022-03-27 | Alexander | Illinois | 17003 | 1274 | 15 |
2348472 | 2348472 | 2022-03-27 | Alexander | North Carolina | 37003 | 10399 | 133 |
2343913 | 2343913 | 2022-03-26 | Alexander | Illinois | 17003 | 1274 | 15 |
2345219 | 2345219 | 2022-03-26 | Alexander | North Carolina | 37003 | 10399 | 133 |
2340660 | 2340660 | 2022-03-25 | Alexander | Illinois | 17003 | 1274 | 15 |
2341966 | 2341966 | 2022-03-25 | Alexander | North Carolina | 37003 | 10399 | 133 |
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);