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)
Suggested facets: date (date)
state 4
- Alabama 785
- Georgia 785
- Mississippi 782
- Texas 780
county 1
- Lamar · 3,132 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499612 | 2499612 | 2022-05-13 | Lamar | Alabama | 1075 | 3745 | 65 |
2500050 | 2500050 | 2022-05-13 | Lamar | Georgia | 13171 | 4864 | 113 |
2501029 | 2501029 | 2022-05-13 | Lamar | Mississippi | 28073 | 17441 | 160 |
2502346 | 2502346 | 2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 |
2496354 | 2496354 | 2022-05-12 | Lamar | Alabama | 1075 | 3745 | 65 |
2496792 | 2496792 | 2022-05-12 | Lamar | Georgia | 13171 | 4864 | 113 |
2497771 | 2497771 | 2022-05-12 | Lamar | Mississippi | 28073 | 17441 | 160 |
2499088 | 2499088 | 2022-05-12 | Lamar | Texas | 48277 | 12500 | 256 |
2493096 | 2493096 | 2022-05-11 | Lamar | Alabama | 1075 | 3745 | 65 |
2493534 | 2493534 | 2022-05-11 | Lamar | Georgia | 13171 | 4864 | 113 |
2494513 | 2494513 | 2022-05-11 | Lamar | Mississippi | 28073 | 17441 | 160 |
2495830 | 2495830 | 2022-05-11 | Lamar | Texas | 48277 | 12500 | 256 |
2489838 | 2489838 | 2022-05-10 | Lamar | Alabama | 1075 | 3737 | 65 |
2490276 | 2490276 | 2022-05-10 | Lamar | Georgia | 13171 | 4854 | 113 |
2491255 | 2491255 | 2022-05-10 | Lamar | Mississippi | 28073 | 17441 | 160 |
2492572 | 2492572 | 2022-05-10 | Lamar | Texas | 48277 | 12500 | 256 |
2486581 | 2486581 | 2022-05-09 | Lamar | Alabama | 1075 | 3735 | 65 |
2487019 | 2487019 | 2022-05-09 | Lamar | Georgia | 13171 | 4854 | 113 |
2487998 | 2487998 | 2022-05-09 | Lamar | Mississippi | 28073 | 17441 | 160 |
2489314 | 2489314 | 2022-05-09 | Lamar | Texas | 48277 | 12500 | 256 |
2483323 | 2483323 | 2022-05-08 | Lamar | Alabama | 1075 | 3735 | 65 |
2483761 | 2483761 | 2022-05-08 | Lamar | Georgia | 13171 | 4854 | 113 |
2484740 | 2484740 | 2022-05-08 | Lamar | Mississippi | 28073 | 17408 | 160 |
2486057 | 2486057 | 2022-05-08 | Lamar | Texas | 48277 | 12491 | 256 |
2480065 | 2480065 | 2022-05-07 | Lamar | Alabama | 1075 | 3735 | 65 |
2480503 | 2480503 | 2022-05-07 | Lamar | Georgia | 13171 | 4854 | 113 |
2481482 | 2481482 | 2022-05-07 | Lamar | Mississippi | 28073 | 17408 | 160 |
2482799 | 2482799 | 2022-05-07 | Lamar | Texas | 48277 | 12491 | 256 |
2476807 | 2476807 | 2022-05-06 | Lamar | Alabama | 1075 | 3735 | 65 |
2477245 | 2477245 | 2022-05-06 | Lamar | Georgia | 13171 | 4854 | 113 |
2478224 | 2478224 | 2022-05-06 | Lamar | Mississippi | 28073 | 17408 | 160 |
2479541 | 2479541 | 2022-05-06 | Lamar | Texas | 48277 | 12491 | 256 |
2473549 | 2473549 | 2022-05-05 | Lamar | Alabama | 1075 | 3734 | 65 |
2473987 | 2473987 | 2022-05-05 | Lamar | Georgia | 13171 | 4854 | 113 |
2474966 | 2474966 | 2022-05-05 | Lamar | Mississippi | 28073 | 17408 | 160 |
2476283 | 2476283 | 2022-05-05 | Lamar | Texas | 48277 | 12491 | 256 |
2470292 | 2470292 | 2022-05-04 | Lamar | Alabama | 1075 | 3734 | 65 |
2470730 | 2470730 | 2022-05-04 | Lamar | Georgia | 13171 | 4854 | 113 |
2471709 | 2471709 | 2022-05-04 | Lamar | Mississippi | 28073 | 17408 | 160 |
2473026 | 2473026 | 2022-05-04 | Lamar | Texas | 48277 | 12491 | 256 |
2467036 | 2467036 | 2022-05-03 | Lamar | Alabama | 1075 | 3734 | 64 |
2467474 | 2467474 | 2022-05-03 | Lamar | Georgia | 13171 | 4848 | 112 |
2468453 | 2468453 | 2022-05-03 | Lamar | Mississippi | 28073 | 17408 | 160 |
2469770 | 2469770 | 2022-05-03 | Lamar | Texas | 48277 | 12491 | 256 |
2463781 | 2463781 | 2022-05-02 | Lamar | Alabama | 1075 | 3733 | 64 |
2464219 | 2464219 | 2022-05-02 | Lamar | Georgia | 13171 | 4848 | 112 |
2465198 | 2465198 | 2022-05-02 | Lamar | Mississippi | 28073 | 17408 | 160 |
2466514 | 2466514 | 2022-05-02 | Lamar | Texas | 48277 | 12491 | 256 |
2460525 | 2460525 | 2022-05-01 | Lamar | Alabama | 1075 | 3733 | 64 |
2460963 | 2460963 | 2022-05-01 | Lamar | Georgia | 13171 | 4848 | 112 |
2461942 | 2461942 | 2022-05-01 | Lamar | Mississippi | 28073 | 17393 | 160 |
2463259 | 2463259 | 2022-05-01 | Lamar | Texas | 48277 | 12488 | 256 |
2457269 | 2457269 | 2022-04-30 | Lamar | Alabama | 1075 | 3733 | 64 |
2457707 | 2457707 | 2022-04-30 | Lamar | Georgia | 13171 | 4848 | 112 |
2458686 | 2458686 | 2022-04-30 | Lamar | Mississippi | 28073 | 17393 | 160 |
2460003 | 2460003 | 2022-04-30 | Lamar | Texas | 48277 | 12488 | 256 |
2454013 | 2454013 | 2022-04-29 | Lamar | Alabama | 1075 | 3733 | 64 |
2454451 | 2454451 | 2022-04-29 | Lamar | Georgia | 13171 | 4848 | 112 |
2455430 | 2455430 | 2022-04-29 | Lamar | Mississippi | 28073 | 17393 | 160 |
2456747 | 2456747 | 2022-04-29 | Lamar | Texas | 48277 | 12488 | 256 |
2450757 | 2450757 | 2022-04-28 | Lamar | Alabama | 1075 | 3733 | 64 |
2451195 | 2451195 | 2022-04-28 | Lamar | Georgia | 13171 | 4848 | 112 |
2452174 | 2452174 | 2022-04-28 | Lamar | Mississippi | 28073 | 17393 | 160 |
2453491 | 2453491 | 2022-04-28 | Lamar | Texas | 48277 | 12488 | 255 |
2447501 | 2447501 | 2022-04-27 | Lamar | Alabama | 1075 | 3733 | 64 |
2447939 | 2447939 | 2022-04-27 | Lamar | Georgia | 13171 | 4848 | 112 |
2448918 | 2448918 | 2022-04-27 | Lamar | Mississippi | 28073 | 17393 | 160 |
2450235 | 2450235 | 2022-04-27 | Lamar | Texas | 48277 | 12488 | 255 |
2444245 | 2444245 | 2022-04-26 | Lamar | Alabama | 1075 | 3728 | 64 |
2444683 | 2444683 | 2022-04-26 | Lamar | Georgia | 13171 | 4847 | 112 |
2445662 | 2445662 | 2022-04-26 | Lamar | Mississippi | 28073 | 17393 | 160 |
2446978 | 2446978 | 2022-04-26 | Lamar | Texas | 48277 | 12487 | 255 |
2440989 | 2440989 | 2022-04-25 | Lamar | Alabama | 1075 | 3728 | 64 |
2441427 | 2441427 | 2022-04-25 | Lamar | Georgia | 13171 | 4847 | 112 |
2442406 | 2442406 | 2022-04-25 | Lamar | Mississippi | 28073 | 17379 | 160 |
2443723 | 2443723 | 2022-04-25 | Lamar | Texas | 48277 | 12486 | 255 |
2437733 | 2437733 | 2022-04-24 | Lamar | Alabama | 1075 | 3727 | 64 |
2438171 | 2438171 | 2022-04-24 | Lamar | Georgia | 13171 | 4846 | 112 |
2439150 | 2439150 | 2022-04-24 | Lamar | Mississippi | 28073 | 17379 | 160 |
2440467 | 2440467 | 2022-04-24 | Lamar | Texas | 48277 | 12486 | 255 |
2434477 | 2434477 | 2022-04-23 | Lamar | Alabama | 1075 | 3727 | 64 |
2434915 | 2434915 | 2022-04-23 | Lamar | Georgia | 13171 | 4846 | 112 |
2435894 | 2435894 | 2022-04-23 | Lamar | Mississippi | 28073 | 17379 | 160 |
2437211 | 2437211 | 2022-04-23 | Lamar | Texas | 48277 | 12486 | 255 |
2431221 | 2431221 | 2022-04-22 | Lamar | Alabama | 1075 | 3727 | 64 |
2431659 | 2431659 | 2022-04-22 | Lamar | Georgia | 13171 | 4846 | 112 |
2432638 | 2432638 | 2022-04-22 | Lamar | Mississippi | 28073 | 17379 | 160 |
2433955 | 2433955 | 2022-04-22 | Lamar | Texas | 48277 | 12486 | 255 |
2427965 | 2427965 | 2022-04-21 | Lamar | Alabama | 1075 | 3727 | 64 |
2428403 | 2428403 | 2022-04-21 | Lamar | Georgia | 13171 | 4846 | 112 |
2429382 | 2429382 | 2022-04-21 | Lamar | Mississippi | 28073 | 17379 | 160 |
2430699 | 2430699 | 2022-04-21 | Lamar | Texas | 48277 | 12486 | 255 |
2424709 | 2424709 | 2022-04-20 | Lamar | Alabama | 1075 | 3727 | 64 |
2425147 | 2425147 | 2022-04-20 | Lamar | Georgia | 13171 | 4846 | 112 |
2426126 | 2426126 | 2022-04-20 | Lamar | Mississippi | 28073 | 17379 | 160 |
2427443 | 2427443 | 2022-04-20 | Lamar | Texas | 48277 | 12485 | 255 |
2421453 | 2421453 | 2022-04-19 | Lamar | Alabama | 1075 | 3726 | 64 |
2421891 | 2421891 | 2022-04-19 | Lamar | Georgia | 13171 | 4845 | 112 |
2422870 | 2422870 | 2022-04-19 | Lamar | Mississippi | 28073 | 17379 | 160 |
2424187 | 2424187 | 2022-04-19 | Lamar | Texas | 48277 | 12485 | 255 |
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);