ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lamar" and fips = 28073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419614 | 2419614 | 2022-04-18 | Lamar | Mississippi | 28073 | 17379 | 160 |
2416358 | 2416358 | 2022-04-17 | Lamar | Mississippi | 28073 | 17362 | 160 |
2413102 | 2413102 | 2022-04-16 | Lamar | Mississippi | 28073 | 17362 | 160 |
2409846 | 2409846 | 2022-04-15 | Lamar | Mississippi | 28073 | 17362 | 160 |
2406590 | 2406590 | 2022-04-14 | Lamar | Mississippi | 28073 | 17362 | 160 |
2403334 | 2403334 | 2022-04-13 | Lamar | Mississippi | 28073 | 17362 | 160 |
2400080 | 2400080 | 2022-04-12 | Lamar | Mississippi | 28073 | 17362 | 160 |
2396824 | 2396824 | 2022-04-11 | Lamar | Mississippi | 28073 | 17343 | 160 |
2393569 | 2393569 | 2022-04-10 | Lamar | Mississippi | 28073 | 17343 | 160 |
2390313 | 2390313 | 2022-04-09 | Lamar | Mississippi | 28073 | 17343 | 160 |
2387057 | 2387057 | 2022-04-08 | Lamar | Mississippi | 28073 | 17343 | 160 |
2383802 | 2383802 | 2022-04-07 | Lamar | Mississippi | 28073 | 17343 | 160 |
2380547 | 2380547 | 2022-04-06 | Lamar | Mississippi | 28073 | 17343 | 160 |
2377292 | 2377292 | 2022-04-05 | Lamar | Mississippi | 28073 | 17343 | 160 |
2374040 | 2374040 | 2022-04-04 | Lamar | Mississippi | 28073 | 17343 | 160 |
2370787 | 2370787 | 2022-04-03 | Lamar | Mississippi | 28073 | 17336 | 160 |
2367534 | 2367534 | 2022-04-02 | Lamar | Mississippi | 28073 | 17336 | 160 |
2364281 | 2364281 | 2022-04-01 | Lamar | Mississippi | 28073 | 17336 | 160 |
2361027 | 2361027 | 2022-03-31 | Lamar | Mississippi | 28073 | 17336 | 160 |
2357773 | 2357773 | 2022-03-30 | Lamar | Mississippi | 28073 | 17336 | 160 |
2354520 | 2354520 | 2022-03-29 | Lamar | Mississippi | 28073 | 17336 | 160 |
2351268 | 2351268 | 2022-03-28 | Lamar | Mississippi | 28073 | 17336 | 160 |
2348015 | 2348015 | 2022-03-27 | Lamar | Mississippi | 28073 | 17332 | 160 |
2344762 | 2344762 | 2022-03-26 | Lamar | Mississippi | 28073 | 17332 | 160 |
2341509 | 2341509 | 2022-03-25 | Lamar | Mississippi | 28073 | 17332 | 160 |
2338256 | 2338256 | 2022-03-24 | Lamar | Mississippi | 28073 | 17332 | 160 |
2335002 | 2335002 | 2022-03-23 | Lamar | Mississippi | 28073 | 17332 | 160 |
2331748 | 2331748 | 2022-03-22 | Lamar | Mississippi | 28073 | 17332 | 160 |
2328496 | 2328496 | 2022-03-21 | Lamar | Mississippi | 28073 | 17332 | 160 |
2325243 | 2325243 | 2022-03-20 | Lamar | Mississippi | 28073 | 17324 | 160 |
2321989 | 2321989 | 2022-03-19 | Lamar | Mississippi | 28073 | 17324 | 160 |
2318735 | 2318735 | 2022-03-18 | Lamar | Mississippi | 28073 | 17324 | 160 |
2315482 | 2315482 | 2022-03-17 | Lamar | Mississippi | 28073 | 17324 | 160 |
2312229 | 2312229 | 2022-03-16 | Lamar | Mississippi | 28073 | 17324 | 160 |
2308976 | 2308976 | 2022-03-15 | Lamar | Mississippi | 28073 | 17324 | 160 |
2305725 | 2305725 | 2022-03-14 | Lamar | Mississippi | 28073 | 17324 | 160 |
2302473 | 2302473 | 2022-03-13 | Lamar | Mississippi | 28073 | 17320 | 160 |
2299221 | 2299221 | 2022-03-12 | Lamar | Mississippi | 28073 | 17320 | 160 |
2295969 | 2295969 | 2022-03-11 | Lamar | Mississippi | 28073 | 17320 | 160 |
2292717 | 2292717 | 2022-03-10 | Lamar | Mississippi | 28073 | 17320 | 160 |
2289465 | 2289465 | 2022-03-09 | Lamar | Mississippi | 28073 | 17320 | 160 |
2286214 | 2286214 | 2022-03-08 | Lamar | Mississippi | 28073 | 17320 | 160 |
2282962 | 2282962 | 2022-03-07 | Lamar | Mississippi | 28073 | 17320 | 160 |
2279709 | 2279709 | 2022-03-06 | Lamar | Mississippi | 28073 | 17310 | 160 |
2276456 | 2276456 | 2022-03-05 | Lamar | Mississippi | 28073 | 17310 | 160 |
2273203 | 2273203 | 2022-03-04 | Lamar | Mississippi | 28073 | 17310 | 160 |
2269951 | 2269951 | 2022-03-03 | Lamar | Mississippi | 28073 | 17309 | 160 |
2266698 | 2266698 | 2022-03-02 | Lamar | Mississippi | 28073 | 17305 | 160 |
2263447 | 2263447 | 2022-03-01 | Lamar | Mississippi | 28073 | 17301 | 160 |
2260196 | 2260196 | 2022-02-28 | Lamar | Mississippi | 28073 | 17292 | 157 |
2256945 | 2256945 | 2022-02-27 | Lamar | Mississippi | 28073 | 17282 | 157 |
2253694 | 2253694 | 2022-02-26 | Lamar | Mississippi | 28073 | 17282 | 157 |
2250443 | 2250443 | 2022-02-25 | Lamar | Mississippi | 28073 | 17282 | 157 |
2247192 | 2247192 | 2022-02-24 | Lamar | Mississippi | 28073 | 17273 | 156 |
2243941 | 2243941 | 2022-02-23 | Lamar | Mississippi | 28073 | 17256 | 156 |
2240690 | 2240690 | 2022-02-22 | Lamar | Mississippi | 28073 | 17238 | 150 |
2237439 | 2237439 | 2022-02-21 | Lamar | Mississippi | 28073 | 17199 | 150 |
2234188 | 2234188 | 2022-02-20 | Lamar | Mississippi | 28073 | 17199 | 150 |
2230937 | 2230937 | 2022-02-19 | Lamar | Mississippi | 28073 | 17199 | 150 |
2227686 | 2227686 | 2022-02-18 | Lamar | Mississippi | 28073 | 17199 | 150 |
2224435 | 2224435 | 2022-02-17 | Lamar | Mississippi | 28073 | 17177 | 150 |
2221184 | 2221184 | 2022-02-16 | Lamar | Mississippi | 28073 | 17149 | 150 |
2217933 | 2217933 | 2022-02-15 | Lamar | Mississippi | 28073 | 17115 | 150 |
2214682 | 2214682 | 2022-02-14 | Lamar | Mississippi | 28073 | 17095 | 150 |
2211430 | 2211430 | 2022-02-13 | Lamar | Mississippi | 28073 | 16981 | 148 |
2208177 | 2208177 | 2022-02-12 | Lamar | Mississippi | 28073 | 16981 | 148 |
2204924 | 2204924 | 2022-02-11 | Lamar | Mississippi | 28073 | 16981 | 148 |
2201671 | 2201671 | 2022-02-10 | Lamar | Mississippi | 28073 | 16879 | 148 |
2198417 | 2198417 | 2022-02-09 | Lamar | Mississippi | 28073 | 16837 | 148 |
2195163 | 2195163 | 2022-02-08 | Lamar | Mississippi | 28073 | 16739 | 148 |
2191909 | 2191909 | 2022-02-07 | Lamar | Mississippi | 28073 | 16709 | 145 |
2188656 | 2188656 | 2022-02-06 | Lamar | Mississippi | 28073 | 16339 | 145 |
2185403 | 2185403 | 2022-02-05 | Lamar | Mississippi | 28073 | 16339 | 145 |
2182151 | 2182151 | 2022-02-04 | Lamar | Mississippi | 28073 | 16339 | 145 |
2178899 | 2178899 | 2022-02-03 | Lamar | Mississippi | 28073 | 16168 | 144 |
2175647 | 2175647 | 2022-02-02 | Lamar | Mississippi | 28073 | 16019 | 144 |
2172394 | 2172394 | 2022-02-01 | Lamar | Mississippi | 28073 | 15942 | 144 |
2169141 | 2169141 | 2022-01-31 | Lamar | Mississippi | 28073 | 15846 | 144 |
2165886 | 2165886 | 2022-01-30 | Lamar | Mississippi | 28073 | 15597 | 143 |
2162631 | 2162631 | 2022-01-29 | Lamar | Mississippi | 28073 | 15597 | 143 |
2159376 | 2159376 | 2022-01-28 | Lamar | Mississippi | 28073 | 15597 | 143 |
2156122 | 2156122 | 2022-01-27 | Lamar | Mississippi | 28073 | 15452 | 143 |
2152869 | 2152869 | 2022-01-26 | Lamar | Mississippi | 28073 | 15320 | 142 |
2149617 | 2149617 | 2022-01-25 | Lamar | Mississippi | 28073 | 15140 | 142 |
2146365 | 2146365 | 2022-01-24 | Lamar | Mississippi | 28073 | 15065 | 142 |
2143110 | 2143110 | 2022-01-23 | Lamar | Mississippi | 28073 | 14646 | 142 |
2139855 | 2139855 | 2022-01-22 | Lamar | Mississippi | 28073 | 14646 | 142 |
2136599 | 2136599 | 2022-01-21 | Lamar | Mississippi | 28073 | 14646 | 142 |
2133347 | 2133347 | 2022-01-20 | Lamar | Mississippi | 28073 | 14453 | 142 |
2130094 | 2130094 | 2022-01-19 | Lamar | Mississippi | 28073 | 14201 | 142 |
2126840 | 2126840 | 2022-01-18 | Lamar | Mississippi | 28073 | 13981 | 142 |
2123588 | 2123588 | 2022-01-17 | Lamar | Mississippi | 28073 | 13445 | 142 |
2120336 | 2120336 | 2022-01-16 | Lamar | Mississippi | 28073 | 13445 | 142 |
2117084 | 2117084 | 2022-01-15 | Lamar | Mississippi | 28073 | 13445 | 142 |
2113833 | 2113833 | 2022-01-14 | Lamar | Mississippi | 28073 | 13445 | 142 |
2110581 | 2110581 | 2022-01-13 | Lamar | Mississippi | 28073 | 13178 | 140 |
2107330 | 2107330 | 2022-01-12 | Lamar | Mississippi | 28073 | 12923 | 141 |
2104079 | 2104079 | 2022-01-11 | Lamar | Mississippi | 28073 | 12653 | 140 |
2100828 | 2100828 | 2022-01-10 | Lamar | Mississippi | 28073 | 12569 | 140 |
2097577 | 2097577 | 2022-01-09 | Lamar | Mississippi | 28073 | 12186 | 140 |
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);