ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lafayette" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449020 | 2449020 | 2022-04-27 | Lafayette | Missouri | 29107 | 7793 | 128 |
2445763 | 2445763 | 2022-04-26 | Lafayette | Missouri | 29107 | 7793 | 128 |
2442508 | 2442508 | 2022-04-25 | Lafayette | Missouri | 29107 | 7793 | 128 |
2439252 | 2439252 | 2022-04-24 | Lafayette | Missouri | 29107 | 7793 | 128 |
2435996 | 2435996 | 2022-04-23 | Lafayette | Missouri | 29107 | 7793 | 128 |
2432740 | 2432740 | 2022-04-22 | Lafayette | Missouri | 29107 | 7793 | 128 |
2429484 | 2429484 | 2022-04-21 | Lafayette | Missouri | 29107 | 7793 | 128 |
2426228 | 2426228 | 2022-04-20 | Lafayette | Missouri | 29107 | 7793 | 128 |
2422972 | 2422972 | 2022-04-19 | Lafayette | Missouri | 29107 | 7793 | 128 |
2419715 | 2419715 | 2022-04-18 | Lafayette | Missouri | 29107 | 7793 | 128 |
2416460 | 2416460 | 2022-04-17 | Lafayette | Missouri | 29107 | 7793 | 128 |
2413204 | 2413204 | 2022-04-16 | Lafayette | Missouri | 29107 | 7793 | 128 |
2409948 | 2409948 | 2022-04-15 | Lafayette | Missouri | 29107 | 7793 | 128 |
2406692 | 2406692 | 2022-04-14 | Lafayette | Missouri | 29107 | 7793 | 128 |
2403436 | 2403436 | 2022-04-13 | Lafayette | Missouri | 29107 | 7793 | 128 |
2400181 | 2400181 | 2022-04-12 | Lafayette | Missouri | 29107 | 7793 | 128 |
2396926 | 2396926 | 2022-04-11 | Lafayette | Missouri | 29107 | 7793 | 128 |
2393671 | 2393671 | 2022-04-10 | Lafayette | Missouri | 29107 | 7793 | 128 |
2390415 | 2390415 | 2022-04-09 | Lafayette | Missouri | 29107 | 7793 | 128 |
2387159 | 2387159 | 2022-04-08 | Lafayette | Missouri | 29107 | 7793 | 128 |
2383904 | 2383904 | 2022-04-07 | Lafayette | Missouri | 29107 | 7793 | 128 |
2380649 | 2380649 | 2022-04-06 | Lafayette | Missouri | 29107 | 7793 | 128 |
2377394 | 2377394 | 2022-04-05 | Lafayette | Missouri | 29107 | 7793 | 128 |
2374141 | 2374141 | 2022-04-04 | Lafayette | Missouri | 29107 | 7793 | 128 |
2370889 | 2370889 | 2022-04-03 | Lafayette | Missouri | 29107 | 7793 | 128 |
2367636 | 2367636 | 2022-04-02 | Lafayette | Missouri | 29107 | 7793 | 128 |
2364383 | 2364383 | 2022-04-01 | Lafayette | Missouri | 29107 | 7793 | 128 |
2361129 | 2361129 | 2022-03-31 | Lafayette | Missouri | 29107 | 7793 | 128 |
2357875 | 2357875 | 2022-03-30 | Lafayette | Missouri | 29107 | 7790 | 128 |
2354622 | 2354622 | 2022-03-29 | Lafayette | Missouri | 29107 | 7787 | 128 |
2351369 | 2351369 | 2022-03-28 | Lafayette | Missouri | 29107 | 7784 | 128 |
2348117 | 2348117 | 2022-03-27 | Lafayette | Missouri | 29107 | 7783 | 128 |
2344864 | 2344864 | 2022-03-26 | Lafayette | Missouri | 29107 | 7783 | 128 |
2341611 | 2341611 | 2022-03-25 | Lafayette | Missouri | 29107 | 7783 | 128 |
2338358 | 2338358 | 2022-03-24 | Lafayette | Missouri | 29107 | 7781 | 128 |
2335104 | 2335104 | 2022-03-23 | Lafayette | Missouri | 29107 | 7768 | 128 |
2331850 | 2331850 | 2022-03-22 | Lafayette | Missouri | 29107 | 7767 | 128 |
2328597 | 2328597 | 2022-03-21 | Lafayette | Missouri | 29107 | 7763 | 127 |
2325345 | 2325345 | 2022-03-20 | Lafayette | Missouri | 29107 | 7762 | 126 |
2322091 | 2322091 | 2022-03-19 | Lafayette | Missouri | 29107 | 7762 | 126 |
2318837 | 2318837 | 2022-03-18 | Lafayette | Missouri | 29107 | 7762 | 126 |
2315584 | 2315584 | 2022-03-17 | Lafayette | Missouri | 29107 | 7761 | 126 |
2312331 | 2312331 | 2022-03-16 | Lafayette | Missouri | 29107 | 7760 | 126 |
2309078 | 2309078 | 2022-03-15 | Lafayette | Missouri | 29107 | 7750 | 126 |
2305826 | 2305826 | 2022-03-14 | Lafayette | Missouri | 29107 | 7744 | 125 |
2302575 | 2302575 | 2022-03-13 | Lafayette | Missouri | 29107 | 7736 | 125 |
2299323 | 2299323 | 2022-03-12 | Lafayette | Missouri | 29107 | 7736 | 125 |
2296071 | 2296071 | 2022-03-11 | Lafayette | Missouri | 29107 | 7736 | 125 |
2292819 | 2292819 | 2022-03-10 | Lafayette | Missouri | 29107 | 7730 | 125 |
2289567 | 2289567 | 2022-03-09 | Lafayette | Missouri | 29107 | 7724 | 124 |
2286315 | 2286315 | 2022-03-08 | Lafayette | Missouri | 29107 | 7694 | 124 |
2283063 | 2283063 | 2022-03-07 | Lafayette | Missouri | 29107 | 7686 | 123 |
2279810 | 2279810 | 2022-03-06 | Lafayette | Missouri | 29107 | 7681 | 123 |
2276557 | 2276557 | 2022-03-05 | Lafayette | Missouri | 29107 | 7681 | 123 |
2273304 | 2273304 | 2022-03-04 | Lafayette | Missouri | 29107 | 7681 | 123 |
2270052 | 2270052 | 2022-03-03 | Lafayette | Missouri | 29107 | 7682 | 123 |
2266799 | 2266799 | 2022-03-02 | Lafayette | Missouri | 29107 | 7690 | 123 |
2263548 | 2263548 | 2022-03-01 | Lafayette | Missouri | 29107 | 7690 | 123 |
2260297 | 2260297 | 2022-02-28 | Lafayette | Missouri | 29107 | 7703 | 122 |
2257046 | 2257046 | 2022-02-27 | Lafayette | Missouri | 29107 | 7701 | 121 |
2253795 | 2253795 | 2022-02-26 | Lafayette | Missouri | 29107 | 7701 | 121 |
2250544 | 2250544 | 2022-02-25 | Lafayette | Missouri | 29107 | 7701 | 121 |
2247293 | 2247293 | 2022-02-24 | Lafayette | Missouri | 29107 | 7701 | 122 |
2244042 | 2244042 | 2022-02-23 | Lafayette | Missouri | 29107 | 7692 | 118 |
2240791 | 2240791 | 2022-02-22 | Lafayette | Missouri | 29107 | 7688 | 116 |
2237540 | 2237540 | 2022-02-21 | Lafayette | Missouri | 29107 | 7667 | 116 |
2234289 | 2234289 | 2022-02-20 | Lafayette | Missouri | 29107 | 7667 | 116 |
2231038 | 2231038 | 2022-02-19 | Lafayette | Missouri | 29107 | 7667 | 116 |
2227787 | 2227787 | 2022-02-18 | Lafayette | Missouri | 29107 | 7667 | 116 |
2224536 | 2224536 | 2022-02-17 | Lafayette | Missouri | 29107 | 7663 | 116 |
2221285 | 2221285 | 2022-02-16 | Lafayette | Missouri | 29107 | 7652 | 116 |
2218034 | 2218034 | 2022-02-15 | Lafayette | Missouri | 29107 | 7639 | 116 |
2214783 | 2214783 | 2022-02-14 | Lafayette | Missouri | 29107 | 7629 | 115 |
2211531 | 2211531 | 2022-02-13 | Lafayette | Missouri | 29107 | 7594 | 115 |
2208278 | 2208278 | 2022-02-12 | Lafayette | Missouri | 29107 | 7594 | 115 |
2205025 | 2205025 | 2022-02-11 | Lafayette | Missouri | 29107 | 7594 | 115 |
2201772 | 2201772 | 2022-02-10 | Lafayette | Missouri | 29107 | 7594 | 115 |
2198518 | 2198518 | 2022-02-09 | Lafayette | Missouri | 29107 | 7572 | 115 |
2195264 | 2195264 | 2022-02-08 | Lafayette | Missouri | 29107 | 7553 | 115 |
2192010 | 2192010 | 2022-02-07 | Lafayette | Missouri | 29107 | 7535 | 113 |
2188757 | 2188757 | 2022-02-06 | Lafayette | Missouri | 29107 | 7531 | 113 |
2185504 | 2185504 | 2022-02-05 | Lafayette | Missouri | 29107 | 7517 | 113 |
2182252 | 2182252 | 2022-02-04 | Lafayette | Missouri | 29107 | 7497 | 112 |
2179000 | 2179000 | 2022-02-03 | Lafayette | Missouri | 29107 | 7482 | 112 |
2175748 | 2175748 | 2022-02-02 | Lafayette | Missouri | 29107 | 7451 | 112 |
2172495 | 2172495 | 2022-02-01 | Lafayette | Missouri | 29107 | 7407 | 112 |
2169242 | 2169242 | 2022-01-31 | Lafayette | Missouri | 29107 | 7368 | 110 |
2165987 | 2165987 | 2022-01-30 | Lafayette | Missouri | 29107 | 7349 | 109 |
2162732 | 2162732 | 2022-01-29 | Lafayette | Missouri | 29107 | 7314 | 109 |
2159477 | 2159477 | 2022-01-28 | Lafayette | Missouri | 29107 | 7255 | 109 |
2156223 | 2156223 | 2022-01-27 | Lafayette | Missouri | 29107 | 7205 | 109 |
2152970 | 2152970 | 2022-01-26 | Lafayette | Missouri | 29107 | 7140 | 108 |
2149718 | 2149718 | 2022-01-25 | Lafayette | Missouri | 29107 | 7102 | 107 |
2146466 | 2146466 | 2022-01-24 | Lafayette | Missouri | 29107 | 7053 | 105 |
2143211 | 2143211 | 2022-01-23 | Lafayette | Missouri | 29107 | 7029 | 105 |
2139956 | 2139956 | 2022-01-22 | Lafayette | Missouri | 29107 | 6974 | 105 |
2136700 | 2136700 | 2022-01-21 | Lafayette | Missouri | 29107 | 6909 | 105 |
2133448 | 2133448 | 2022-01-20 | Lafayette | Missouri | 29107 | 6809 | 105 |
2130195 | 2130195 | 2022-01-19 | Lafayette | Missouri | 29107 | 6724 | 103 |
2126941 | 2126941 | 2022-01-18 | Lafayette | Missouri | 29107 | 6662 | 102 |
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);