ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and fips = 29055 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 |
---|---|---|---|---|---|---|---|
2501103 | 2501103 | 2022-05-13 | Crawford | Missouri | 29055 | 5422 | 104 |
2497845 | 2497845 | 2022-05-12 | Crawford | Missouri | 29055 | 5393 | 102 |
2494587 | 2494587 | 2022-05-11 | Crawford | Missouri | 29055 | 5393 | 102 |
2491329 | 2491329 | 2022-05-10 | Crawford | Missouri | 29055 | 5393 | 102 |
2488071 | 2488071 | 2022-05-09 | Crawford | Missouri | 29055 | 5393 | 102 |
2484814 | 2484814 | 2022-05-08 | Crawford | Missouri | 29055 | 5393 | 102 |
2481556 | 2481556 | 2022-05-07 | Crawford | Missouri | 29055 | 5393 | 102 |
2478298 | 2478298 | 2022-05-06 | Crawford | Missouri | 29055 | 5393 | 102 |
2475040 | 2475040 | 2022-05-05 | Crawford | Missouri | 29055 | 5396 | 102 |
2471783 | 2471783 | 2022-05-04 | Crawford | Missouri | 29055 | 5396 | 101 |
2468527 | 2468527 | 2022-05-03 | Crawford | Missouri | 29055 | 5396 | 101 |
2465271 | 2465271 | 2022-05-02 | Crawford | Missouri | 29055 | 5396 | 101 |
2462016 | 2462016 | 2022-05-01 | Crawford | Missouri | 29055 | 5396 | 101 |
2458760 | 2458760 | 2022-04-30 | Crawford | Missouri | 29055 | 5396 | 101 |
2455504 | 2455504 | 2022-04-29 | Crawford | Missouri | 29055 | 5396 | 101 |
2452248 | 2452248 | 2022-04-28 | Crawford | Missouri | 29055 | 5396 | 101 |
2448992 | 2448992 | 2022-04-27 | Crawford | Missouri | 29055 | 5396 | 101 |
2445735 | 2445735 | 2022-04-26 | Crawford | Missouri | 29055 | 5396 | 101 |
2442480 | 2442480 | 2022-04-25 | Crawford | Missouri | 29055 | 5396 | 101 |
2439224 | 2439224 | 2022-04-24 | Crawford | Missouri | 29055 | 5396 | 101 |
2435968 | 2435968 | 2022-04-23 | Crawford | Missouri | 29055 | 5396 | 101 |
2432712 | 2432712 | 2022-04-22 | Crawford | Missouri | 29055 | 5396 | 101 |
2429456 | 2429456 | 2022-04-21 | Crawford | Missouri | 29055 | 5396 | 101 |
2426200 | 2426200 | 2022-04-20 | Crawford | Missouri | 29055 | 5396 | 101 |
2422944 | 2422944 | 2022-04-19 | Crawford | Missouri | 29055 | 5396 | 101 |
2419687 | 2419687 | 2022-04-18 | Crawford | Missouri | 29055 | 5396 | 101 |
2416432 | 2416432 | 2022-04-17 | Crawford | Missouri | 29055 | 5396 | 101 |
2413176 | 2413176 | 2022-04-16 | Crawford | Missouri | 29055 | 5396 | 101 |
2409920 | 2409920 | 2022-04-15 | Crawford | Missouri | 29055 | 5396 | 101 |
2406664 | 2406664 | 2022-04-14 | Crawford | Missouri | 29055 | 5396 | 101 |
2403408 | 2403408 | 2022-04-13 | Crawford | Missouri | 29055 | 5396 | 101 |
2400153 | 2400153 | 2022-04-12 | Crawford | Missouri | 29055 | 5396 | 101 |
2396898 | 2396898 | 2022-04-11 | Crawford | Missouri | 29055 | 5396 | 101 |
2393643 | 2393643 | 2022-04-10 | Crawford | Missouri | 29055 | 5396 | 101 |
2390387 | 2390387 | 2022-04-09 | Crawford | Missouri | 29055 | 5396 | 101 |
2387131 | 2387131 | 2022-04-08 | Crawford | Missouri | 29055 | 5396 | 101 |
2383876 | 2383876 | 2022-04-07 | Crawford | Missouri | 29055 | 5396 | 101 |
2380621 | 2380621 | 2022-04-06 | Crawford | Missouri | 29055 | 5396 | 101 |
2377366 | 2377366 | 2022-04-05 | Crawford | Missouri | 29055 | 5396 | 101 |
2374113 | 2374113 | 2022-04-04 | Crawford | Missouri | 29055 | 5396 | 101 |
2370861 | 2370861 | 2022-04-03 | Crawford | Missouri | 29055 | 5396 | 101 |
2367608 | 2367608 | 2022-04-02 | Crawford | Missouri | 29055 | 5396 | 101 |
2364355 | 2364355 | 2022-04-01 | Crawford | Missouri | 29055 | 5396 | 101 |
2361101 | 2361101 | 2022-03-31 | Crawford | Missouri | 29055 | 5396 | 101 |
2357847 | 2357847 | 2022-03-30 | Crawford | Missouri | 29055 | 5394 | 101 |
2354594 | 2354594 | 2022-03-29 | Crawford | Missouri | 29055 | 5391 | 101 |
2351341 | 2351341 | 2022-03-28 | Crawford | Missouri | 29055 | 5386 | 101 |
2348089 | 2348089 | 2022-03-27 | Crawford | Missouri | 29055 | 5384 | 101 |
2344836 | 2344836 | 2022-03-26 | Crawford | Missouri | 29055 | 5384 | 101 |
2341583 | 2341583 | 2022-03-25 | Crawford | Missouri | 29055 | 5384 | 101 |
2338330 | 2338330 | 2022-03-24 | Crawford | Missouri | 29055 | 5382 | 101 |
2335076 | 2335076 | 2022-03-23 | Crawford | Missouri | 29055 | 5382 | 101 |
2331822 | 2331822 | 2022-03-22 | Crawford | Missouri | 29055 | 5381 | 101 |
2328569 | 2328569 | 2022-03-21 | Crawford | Missouri | 29055 | 5379 | 100 |
2325317 | 2325317 | 2022-03-20 | Crawford | Missouri | 29055 | 5374 | 100 |
2322063 | 2322063 | 2022-03-19 | Crawford | Missouri | 29055 | 5374 | 100 |
2318809 | 2318809 | 2022-03-18 | Crawford | Missouri | 29055 | 5374 | 100 |
2315556 | 2315556 | 2022-03-17 | Crawford | Missouri | 29055 | 5374 | 100 |
2312303 | 2312303 | 2022-03-16 | Crawford | Missouri | 29055 | 5370 | 100 |
2309050 | 2309050 | 2022-03-15 | Crawford | Missouri | 29055 | 5368 | 100 |
2305798 | 2305798 | 2022-03-14 | Crawford | Missouri | 29055 | 5368 | 97 |
2302547 | 2302547 | 2022-03-13 | Crawford | Missouri | 29055 | 5369 | 97 |
2299295 | 2299295 | 2022-03-12 | Crawford | Missouri | 29055 | 5369 | 97 |
2296043 | 2296043 | 2022-03-11 | Crawford | Missouri | 29055 | 5369 | 97 |
2292791 | 2292791 | 2022-03-10 | Crawford | Missouri | 29055 | 5369 | 97 |
2289539 | 2289539 | 2022-03-09 | Crawford | Missouri | 29055 | 5368 | 97 |
2286287 | 2286287 | 2022-03-08 | Crawford | Missouri | 29055 | 5367 | 97 |
2283035 | 2283035 | 2022-03-07 | Crawford | Missouri | 29055 | 5364 | 97 |
2279782 | 2279782 | 2022-03-06 | Crawford | Missouri | 29055 | 5361 | 97 |
2276529 | 2276529 | 2022-03-05 | Crawford | Missouri | 29055 | 5361 | 97 |
2273276 | 2273276 | 2022-03-04 | Crawford | Missouri | 29055 | 5361 | 97 |
2270024 | 2270024 | 2022-03-03 | Crawford | Missouri | 29055 | 5360 | 97 |
2266771 | 2266771 | 2022-03-02 | Crawford | Missouri | 29055 | 5359 | 97 |
2263520 | 2263520 | 2022-03-01 | Crawford | Missouri | 29055 | 5358 | 97 |
2260269 | 2260269 | 2022-02-28 | Crawford | Missouri | 29055 | 5356 | 96 |
2257018 | 2257018 | 2022-02-27 | Crawford | Missouri | 29055 | 5351 | 96 |
2253767 | 2253767 | 2022-02-26 | Crawford | Missouri | 29055 | 5351 | 96 |
2250516 | 2250516 | 2022-02-25 | Crawford | Missouri | 29055 | 5351 | 96 |
2247265 | 2247265 | 2022-02-24 | Crawford | Missouri | 29055 | 5350 | 96 |
2244014 | 2244014 | 2022-02-23 | Crawford | Missouri | 29055 | 5348 | 94 |
2240763 | 2240763 | 2022-02-22 | Crawford | Missouri | 29055 | 5344 | 94 |
2237512 | 2237512 | 2022-02-21 | Crawford | Missouri | 29055 | 5332 | 94 |
2234261 | 2234261 | 2022-02-20 | Crawford | Missouri | 29055 | 5332 | 94 |
2231010 | 2231010 | 2022-02-19 | Crawford | Missouri | 29055 | 5332 | 94 |
2227759 | 2227759 | 2022-02-18 | Crawford | Missouri | 29055 | 5332 | 94 |
2224508 | 2224508 | 2022-02-17 | Crawford | Missouri | 29055 | 5332 | 94 |
2221257 | 2221257 | 2022-02-16 | Crawford | Missouri | 29055 | 5328 | 94 |
2218006 | 2218006 | 2022-02-15 | Crawford | Missouri | 29055 | 5318 | 94 |
2214755 | 2214755 | 2022-02-14 | Crawford | Missouri | 29055 | 5309 | 94 |
2211503 | 2211503 | 2022-02-13 | Crawford | Missouri | 29055 | 5286 | 94 |
2208250 | 2208250 | 2022-02-12 | Crawford | Missouri | 29055 | 5286 | 94 |
2204997 | 2204997 | 2022-02-11 | Crawford | Missouri | 29055 | 5286 | 94 |
2201744 | 2201744 | 2022-02-10 | Crawford | Missouri | 29055 | 5286 | 94 |
2198490 | 2198490 | 2022-02-09 | Crawford | Missouri | 29055 | 5276 | 94 |
2195236 | 2195236 | 2022-02-08 | Crawford | Missouri | 29055 | 5257 | 94 |
2191982 | 2191982 | 2022-02-07 | Crawford | Missouri | 29055 | 5243 | 92 |
2188729 | 2188729 | 2022-02-06 | Crawford | Missouri | 29055 | 5240 | 91 |
2185476 | 2185476 | 2022-02-05 | Crawford | Missouri | 29055 | 5231 | 91 |
2182224 | 2182224 | 2022-02-04 | Crawford | Missouri | 29055 | 5222 | 91 |
2178972 | 2178972 | 2022-02-03 | Crawford | Missouri | 29055 | 5218 | 91 |
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);