ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,132 rows where county = "Lamar" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- Alabama 760
- Georgia 760
- Mississippi 757
- Texas 755
county 1
- Lamar · 3,032 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418197 | 2418197 | 2022-04-18 | Lamar | Alabama | 1075 | 3726 | 64 |
2418635 | 2418635 | 2022-04-18 | Lamar | Georgia | 13171 | 4845 | 112 |
2419614 | 2419614 | 2022-04-18 | Lamar | Mississippi | 28073 | 17379 | 160 |
2420931 | 2420931 | 2022-04-18 | Lamar | Texas | 48277 | 12484 | 255 |
2414941 | 2414941 | 2022-04-17 | Lamar | Alabama | 1075 | 3726 | 64 |
2415379 | 2415379 | 2022-04-17 | Lamar | Georgia | 13171 | 4845 | 112 |
2416358 | 2416358 | 2022-04-17 | Lamar | Mississippi | 28073 | 17362 | 160 |
2417675 | 2417675 | 2022-04-17 | Lamar | Texas | 48277 | 12484 | 256 |
2411685 | 2411685 | 2022-04-16 | Lamar | Alabama | 1075 | 3726 | 64 |
2412123 | 2412123 | 2022-04-16 | Lamar | Georgia | 13171 | 4845 | 112 |
2413102 | 2413102 | 2022-04-16 | Lamar | Mississippi | 28073 | 17362 | 160 |
2414419 | 2414419 | 2022-04-16 | Lamar | Texas | 48277 | 12484 | 256 |
2408429 | 2408429 | 2022-04-15 | Lamar | Alabama | 1075 | 3726 | 64 |
2408867 | 2408867 | 2022-04-15 | Lamar | Georgia | 13171 | 4845 | 112 |
2409846 | 2409846 | 2022-04-15 | Lamar | Mississippi | 28073 | 17362 | 160 |
2411163 | 2411163 | 2022-04-15 | Lamar | Texas | 48277 | 12484 | 256 |
2405173 | 2405173 | 2022-04-14 | Lamar | Alabama | 1075 | 3726 | 64 |
2405611 | 2405611 | 2022-04-14 | Lamar | Georgia | 13171 | 4844 | 112 |
2406590 | 2406590 | 2022-04-14 | Lamar | Mississippi | 28073 | 17362 | 160 |
2407907 | 2407907 | 2022-04-14 | Lamar | Texas | 48277 | 12484 | 256 |
2401918 | 2401918 | 2022-04-13 | Lamar | Alabama | 1075 | 3726 | 64 |
2402356 | 2402356 | 2022-04-13 | Lamar | Georgia | 13171 | 4844 | 112 |
2403334 | 2403334 | 2022-04-13 | Lamar | Mississippi | 28073 | 17362 | 160 |
2404651 | 2404651 | 2022-04-13 | Lamar | Texas | 48277 | 12484 | 256 |
2398663 | 2398663 | 2022-04-12 | Lamar | Alabama | 1075 | 3726 | 64 |
2399101 | 2399101 | 2022-04-12 | Lamar | Georgia | 13171 | 4843 | 112 |
2400080 | 2400080 | 2022-04-12 | Lamar | Mississippi | 28073 | 17362 | 160 |
2401396 | 2401396 | 2022-04-12 | Lamar | Texas | 48277 | 12484 | 256 |
2395408 | 2395408 | 2022-04-11 | Lamar | Alabama | 1075 | 3724 | 63 |
2395846 | 2395846 | 2022-04-11 | Lamar | Georgia | 13171 | 4842 | 112 |
2396824 | 2396824 | 2022-04-11 | Lamar | Mississippi | 28073 | 17343 | 160 |
2398141 | 2398141 | 2022-04-11 | Lamar | Texas | 48277 | 12484 | 256 |
2392152 | 2392152 | 2022-04-10 | Lamar | Alabama | 1075 | 3724 | 63 |
2392590 | 2392590 | 2022-04-10 | Lamar | Georgia | 13171 | 4841 | 112 |
2393569 | 2393569 | 2022-04-10 | Lamar | Mississippi | 28073 | 17343 | 160 |
2394886 | 2394886 | 2022-04-10 | Lamar | Texas | 48277 | 12483 | 256 |
2388896 | 2388896 | 2022-04-09 | Lamar | Alabama | 1075 | 3724 | 63 |
2389334 | 2389334 | 2022-04-09 | Lamar | Georgia | 13171 | 4841 | 112 |
2390313 | 2390313 | 2022-04-09 | Lamar | Mississippi | 28073 | 17343 | 160 |
2391630 | 2391630 | 2022-04-09 | Lamar | Texas | 48277 | 12483 | 256 |
2385641 | 2385641 | 2022-04-08 | Lamar | Alabama | 1075 | 3724 | 63 |
2386079 | 2386079 | 2022-04-08 | Lamar | Georgia | 13171 | 4841 | 112 |
2387057 | 2387057 | 2022-04-08 | Lamar | Mississippi | 28073 | 17343 | 160 |
2388374 | 2388374 | 2022-04-08 | Lamar | Texas | 48277 | 12483 | 256 |
2382386 | 2382386 | 2022-04-07 | Lamar | Alabama | 1075 | 3724 | 63 |
2382824 | 2382824 | 2022-04-07 | Lamar | Georgia | 13171 | 4841 | 112 |
2383802 | 2383802 | 2022-04-07 | Lamar | Mississippi | 28073 | 17343 | 160 |
2385119 | 2385119 | 2022-04-07 | Lamar | Texas | 48277 | 12483 | 256 |
2379131 | 2379131 | 2022-04-06 | Lamar | Alabama | 1075 | 3724 | 63 |
2379569 | 2379569 | 2022-04-06 | Lamar | Georgia | 13171 | 4842 | 112 |
2380547 | 2380547 | 2022-04-06 | Lamar | Mississippi | 28073 | 17343 | 160 |
2381864 | 2381864 | 2022-04-06 | Lamar | Texas | 48277 | 12483 | 255 |
2375877 | 2375877 | 2022-04-05 | Lamar | Alabama | 1075 | 3723 | 63 |
2376315 | 2376315 | 2022-04-05 | Lamar | Georgia | 13171 | 4843 | 112 |
2377292 | 2377292 | 2022-04-05 | Lamar | Mississippi | 28073 | 17343 | 160 |
2378609 | 2378609 | 2022-04-05 | Lamar | Texas | 48277 | 12483 | 255 |
2372625 | 2372625 | 2022-04-04 | Lamar | Alabama | 1075 | 3723 | 63 |
2373063 | 2373063 | 2022-04-04 | Lamar | Georgia | 13171 | 4843 | 112 |
2374040 | 2374040 | 2022-04-04 | Lamar | Mississippi | 28073 | 17343 | 160 |
2375355 | 2375355 | 2022-04-04 | Lamar | Texas | 48277 | 12478 | 255 |
2369372 | 2369372 | 2022-04-03 | Lamar | Alabama | 1075 | 3723 | 63 |
2369810 | 2369810 | 2022-04-03 | Lamar | Georgia | 13171 | 4842 | 112 |
2370787 | 2370787 | 2022-04-03 | Lamar | Mississippi | 28073 | 17336 | 160 |
2372103 | 2372103 | 2022-04-03 | Lamar | Texas | 48277 | 12478 | 255 |
2366119 | 2366119 | 2022-04-02 | Lamar | Alabama | 1075 | 3723 | 63 |
2366557 | 2366557 | 2022-04-02 | Lamar | Georgia | 13171 | 4842 | 112 |
2367534 | 2367534 | 2022-04-02 | Lamar | Mississippi | 28073 | 17336 | 160 |
2368850 | 2368850 | 2022-04-02 | Lamar | Texas | 48277 | 12478 | 255 |
2362866 | 2362866 | 2022-04-01 | Lamar | Alabama | 1075 | 3723 | 63 |
2363304 | 2363304 | 2022-04-01 | Lamar | Georgia | 13171 | 4842 | 112 |
2364281 | 2364281 | 2022-04-01 | Lamar | Mississippi | 28073 | 17336 | 160 |
2365597 | 2365597 | 2022-04-01 | Lamar | Texas | 48277 | 12478 | 255 |
2359612 | 2359612 | 2022-03-31 | Lamar | Alabama | 1075 | 3723 | 63 |
2360050 | 2360050 | 2022-03-31 | Lamar | Georgia | 13171 | 4841 | 112 |
2361027 | 2361027 | 2022-03-31 | Lamar | Mississippi | 28073 | 17336 | 160 |
2362344 | 2362344 | 2022-03-31 | Lamar | Texas | 48277 | 12478 | 254 |
2356358 | 2356358 | 2022-03-30 | Lamar | Alabama | 1075 | 3723 | 63 |
2356796 | 2356796 | 2022-03-30 | Lamar | Georgia | 13171 | 4838 | 112 |
2357773 | 2357773 | 2022-03-30 | Lamar | Mississippi | 28073 | 17336 | 160 |
2359090 | 2359090 | 2022-03-30 | Lamar | Texas | 48277 | 12478 | 254 |
2353105 | 2353105 | 2022-03-29 | Lamar | Alabama | 1075 | 3723 | 63 |
2353543 | 2353543 | 2022-03-29 | Lamar | Georgia | 13171 | 4837 | 112 |
2354520 | 2354520 | 2022-03-29 | Lamar | Mississippi | 28073 | 17336 | 160 |
2355836 | 2355836 | 2022-03-29 | Lamar | Texas | 48277 | 12478 | 254 |
2349853 | 2349853 | 2022-03-28 | Lamar | Alabama | 1075 | 3714 | 63 |
2350291 | 2350291 | 2022-03-28 | Lamar | Georgia | 13171 | 4837 | 112 |
2351268 | 2351268 | 2022-03-28 | Lamar | Mississippi | 28073 | 17336 | 160 |
2352583 | 2352583 | 2022-03-28 | Lamar | Texas | 48277 | 12478 | 254 |
2346600 | 2346600 | 2022-03-27 | Lamar | Alabama | 1075 | 3712 | 63 |
2347038 | 2347038 | 2022-03-27 | Lamar | Georgia | 13171 | 4837 | 112 |
2348015 | 2348015 | 2022-03-27 | Lamar | Mississippi | 28073 | 17332 | 160 |
2349331 | 2349331 | 2022-03-27 | Lamar | Texas | 48277 | 12478 | 254 |
2343347 | 2343347 | 2022-03-26 | Lamar | Alabama | 1075 | 3712 | 63 |
2343785 | 2343785 | 2022-03-26 | Lamar | Georgia | 13171 | 4837 | 112 |
2344762 | 2344762 | 2022-03-26 | Lamar | Mississippi | 28073 | 17332 | 160 |
2346078 | 2346078 | 2022-03-26 | Lamar | Texas | 48277 | 12478 | 254 |
2340094 | 2340094 | 2022-03-25 | Lamar | Alabama | 1075 | 3712 | 63 |
2340532 | 2340532 | 2022-03-25 | Lamar | Georgia | 13171 | 4837 | 112 |
2341509 | 2341509 | 2022-03-25 | Lamar | Mississippi | 28073 | 17332 | 160 |
2342825 | 2342825 | 2022-03-25 | Lamar | Texas | 48277 | 12478 | 254 |
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);