ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Dallas" and fips = 1047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499598 | 2499598 | 2022-05-13 | Dallas | Alabama | 1047 | 8429 | 244 |
2496340 | 2496340 | 2022-05-12 | Dallas | Alabama | 1047 | 8428 | 244 |
2493082 | 2493082 | 2022-05-11 | Dallas | Alabama | 1047 | 8428 | 244 |
2489824 | 2489824 | 2022-05-10 | Dallas | Alabama | 1047 | 8426 | 244 |
2486567 | 2486567 | 2022-05-09 | Dallas | Alabama | 1047 | 8424 | 244 |
2483309 | 2483309 | 2022-05-08 | Dallas | Alabama | 1047 | 8424 | 244 |
2480051 | 2480051 | 2022-05-07 | Dallas | Alabama | 1047 | 8424 | 244 |
2476793 | 2476793 | 2022-05-06 | Dallas | Alabama | 1047 | 8424 | 244 |
2473535 | 2473535 | 2022-05-05 | Dallas | Alabama | 1047 | 8422 | 244 |
2470278 | 2470278 | 2022-05-04 | Dallas | Alabama | 1047 | 8421 | 244 |
2467022 | 2467022 | 2022-05-03 | Dallas | Alabama | 1047 | 8419 | 244 |
2463767 | 2463767 | 2022-05-02 | Dallas | Alabama | 1047 | 8419 | 244 |
2460511 | 2460511 | 2022-05-01 | Dallas | Alabama | 1047 | 8418 | 244 |
2457255 | 2457255 | 2022-04-30 | Dallas | Alabama | 1047 | 8418 | 244 |
2453999 | 2453999 | 2022-04-29 | Dallas | Alabama | 1047 | 8418 | 244 |
2450743 | 2450743 | 2022-04-28 | Dallas | Alabama | 1047 | 8418 | 244 |
2447487 | 2447487 | 2022-04-27 | Dallas | Alabama | 1047 | 8418 | 244 |
2444231 | 2444231 | 2022-04-26 | Dallas | Alabama | 1047 | 8419 | 244 |
2440975 | 2440975 | 2022-04-25 | Dallas | Alabama | 1047 | 8417 | 244 |
2437719 | 2437719 | 2022-04-24 | Dallas | Alabama | 1047 | 8411 | 244 |
2434463 | 2434463 | 2022-04-23 | Dallas | Alabama | 1047 | 8411 | 244 |
2431207 | 2431207 | 2022-04-22 | Dallas | Alabama | 1047 | 8411 | 244 |
2427951 | 2427951 | 2022-04-21 | Dallas | Alabama | 1047 | 8409 | 244 |
2424695 | 2424695 | 2022-04-20 | Dallas | Alabama | 1047 | 8408 | 244 |
2421439 | 2421439 | 2022-04-19 | Dallas | Alabama | 1047 | 8408 | 244 |
2418183 | 2418183 | 2022-04-18 | Dallas | Alabama | 1047 | 8400 | 243 |
2414927 | 2414927 | 2022-04-17 | Dallas | Alabama | 1047 | 8400 | 243 |
2411671 | 2411671 | 2022-04-16 | Dallas | Alabama | 1047 | 8400 | 243 |
2408415 | 2408415 | 2022-04-15 | Dallas | Alabama | 1047 | 8400 | 243 |
2405159 | 2405159 | 2022-04-14 | Dallas | Alabama | 1047 | 8396 | 243 |
2401904 | 2401904 | 2022-04-13 | Dallas | Alabama | 1047 | 8395 | 242 |
2398649 | 2398649 | 2022-04-12 | Dallas | Alabama | 1047 | 8395 | 242 |
2395394 | 2395394 | 2022-04-11 | Dallas | Alabama | 1047 | 8392 | 242 |
2392138 | 2392138 | 2022-04-10 | Dallas | Alabama | 1047 | 8392 | 242 |
2388882 | 2388882 | 2022-04-09 | Dallas | Alabama | 1047 | 8392 | 242 |
2385627 | 2385627 | 2022-04-08 | Dallas | Alabama | 1047 | 8392 | 242 |
2382372 | 2382372 | 2022-04-07 | Dallas | Alabama | 1047 | 8390 | 242 |
2379117 | 2379117 | 2022-04-06 | Dallas | Alabama | 1047 | 8390 | 242 |
2375863 | 2375863 | 2022-04-05 | Dallas | Alabama | 1047 | 8387 | 242 |
2372611 | 2372611 | 2022-04-04 | Dallas | Alabama | 1047 | 8386 | 242 |
2369358 | 2369358 | 2022-04-03 | Dallas | Alabama | 1047 | 8385 | 242 |
2366105 | 2366105 | 2022-04-02 | Dallas | Alabama | 1047 | 8385 | 242 |
2362852 | 2362852 | 2022-04-01 | Dallas | Alabama | 1047 | 8385 | 242 |
2359598 | 2359598 | 2022-03-31 | Dallas | Alabama | 1047 | 8384 | 242 |
2356344 | 2356344 | 2022-03-30 | Dallas | Alabama | 1047 | 8382 | 242 |
2353091 | 2353091 | 2022-03-29 | Dallas | Alabama | 1047 | 8382 | 242 |
2349839 | 2349839 | 2022-03-28 | Dallas | Alabama | 1047 | 8382 | 242 |
2346586 | 2346586 | 2022-03-27 | Dallas | Alabama | 1047 | 8379 | 241 |
2343333 | 2343333 | 2022-03-26 | Dallas | Alabama | 1047 | 8379 | 241 |
2340080 | 2340080 | 2022-03-25 | Dallas | Alabama | 1047 | 8379 | 241 |
2336827 | 2336827 | 2022-03-24 | Dallas | Alabama | 1047 | 8378 | 241 |
2333573 | 2333573 | 2022-03-23 | Dallas | Alabama | 1047 | 8363 | 241 |
2330319 | 2330319 | 2022-03-22 | Dallas | Alabama | 1047 | 8362 | 241 |
2327067 | 2327067 | 2022-03-21 | Dallas | Alabama | 1047 | 8360 | 240 |
2323814 | 2323814 | 2022-03-20 | Dallas | Alabama | 1047 | 8356 | 240 |
2320560 | 2320560 | 2022-03-19 | Dallas | Alabama | 1047 | 8356 | 240 |
2317306 | 2317306 | 2022-03-18 | Dallas | Alabama | 1047 | 8356 | 240 |
2314053 | 2314053 | 2022-03-17 | Dallas | Alabama | 1047 | 8354 | 239 |
2310800 | 2310800 | 2022-03-16 | Dallas | Alabama | 1047 | 8356 | 237 |
2307547 | 2307547 | 2022-03-15 | Dallas | Alabama | 1047 | 8351 | 237 |
2304296 | 2304296 | 2022-03-14 | Dallas | Alabama | 1047 | 8349 | 236 |
2301044 | 2301044 | 2022-03-13 | Dallas | Alabama | 1047 | 8349 | 236 |
2297792 | 2297792 | 2022-03-12 | Dallas | Alabama | 1047 | 8349 | 236 |
2294540 | 2294540 | 2022-03-11 | Dallas | Alabama | 1047 | 8349 | 236 |
2291288 | 2291288 | 2022-03-10 | Dallas | Alabama | 1047 | 8348 | 236 |
2288036 | 2288036 | 2022-03-09 | Dallas | Alabama | 1047 | 8342 | 235 |
2284784 | 2284784 | 2022-03-08 | Dallas | Alabama | 1047 | 8342 | 233 |
2281532 | 2281532 | 2022-03-07 | Dallas | Alabama | 1047 | 8337 | 232 |
2278279 | 2278279 | 2022-03-06 | Dallas | Alabama | 1047 | 8330 | 231 |
2275026 | 2275026 | 2022-03-05 | Dallas | Alabama | 1047 | 8330 | 231 |
2271773 | 2271773 | 2022-03-04 | Dallas | Alabama | 1047 | 8330 | 231 |
2268521 | 2268521 | 2022-03-03 | Dallas | Alabama | 1047 | 8328 | 231 |
2265268 | 2265268 | 2022-03-02 | Dallas | Alabama | 1047 | 8310 | 230 |
2262018 | 2262018 | 2022-03-01 | Dallas | Alabama | 1047 | 8307 | 229 |
2258767 | 2258767 | 2022-02-28 | Dallas | Alabama | 1047 | 8301 | 229 |
2255516 | 2255516 | 2022-02-27 | Dallas | Alabama | 1047 | 8301 | 229 |
2252265 | 2252265 | 2022-02-26 | Dallas | Alabama | 1047 | 8298 | 229 |
2249014 | 2249014 | 2022-02-25 | Dallas | Alabama | 1047 | 8289 | 229 |
2245763 | 2245763 | 2022-02-24 | Dallas | Alabama | 1047 | 8288 | 228 |
2242512 | 2242512 | 2022-02-23 | Dallas | Alabama | 1047 | 8277 | 228 |
2239261 | 2239261 | 2022-02-22 | Dallas | Alabama | 1047 | 8278 | 228 |
2236010 | 2236010 | 2022-02-21 | Dallas | Alabama | 1047 | 8276 | 228 |
2232759 | 2232759 | 2022-02-20 | Dallas | Alabama | 1047 | 8274 | 228 |
2229508 | 2229508 | 2022-02-19 | Dallas | Alabama | 1047 | 8272 | 228 |
2226257 | 2226257 | 2022-02-18 | Dallas | Alabama | 1047 | 8265 | 228 |
2223006 | 2223006 | 2022-02-17 | Dallas | Alabama | 1047 | 8247 | 228 |
2219755 | 2219755 | 2022-02-16 | Dallas | Alabama | 1047 | 8235 | 228 |
2216505 | 2216505 | 2022-02-15 | Dallas | Alabama | 1047 | 8205 | 227 |
2213254 | 2213254 | 2022-02-14 | Dallas | Alabama | 1047 | 8185 | 226 |
2210001 | 2210001 | 2022-02-13 | Dallas | Alabama | 1047 | 8173 | 226 |
2206748 | 2206748 | 2022-02-12 | Dallas | Alabama | 1047 | 8165 | 226 |
2203495 | 2203495 | 2022-02-11 | Dallas | Alabama | 1047 | 8158 | 226 |
2200241 | 2200241 | 2022-02-10 | Dallas | Alabama | 1047 | 8145 | 226 |
2196987 | 2196987 | 2022-02-09 | Dallas | Alabama | 1047 | 8118 | 226 |
2193732 | 2193732 | 2022-02-08 | Dallas | Alabama | 1047 | 8024 | 226 |
2190479 | 2190479 | 2022-02-07 | Dallas | Alabama | 1047 | 7971 | 226 |
2187226 | 2187226 | 2022-02-06 | Dallas | Alabama | 1047 | 7960 | 226 |
2183973 | 2183973 | 2022-02-05 | Dallas | Alabama | 1047 | 7960 | 226 |
2180721 | 2180721 | 2022-02-04 | Dallas | Alabama | 1047 | 7944 | 226 |
2177470 | 2177470 | 2022-02-03 | Dallas | Alabama | 1047 | 7870 | 225 |
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);