ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,522 rows where county = "Lawrence" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- South Dakota 769
- Tennessee 769
- Alabama 768
- Arkansas 768
- Indiana 768
- Kentucky 768
- Mississippi 768
- Ohio 768
- Pennsylvania 768
- Illinois 767
- Missouri 741
fips 11
county 1
- Lawrence · 8,422 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
35051 | 35051 | 2020-04-05 | Lawrence | South Dakota | 46081 | 9 | 0 |
35110 | 35110 | 2020-04-05 | Lawrence | Tennessee | 47099 | 3 | 0 |
35635 | 35635 | 2020-04-06 | Lawrence | Alabama | 1079 | 8 | 0 |
35721 | 35721 | 2020-04-06 | Lawrence | Arkansas | 5075 | 3 | 1 |
36252 | 36252 | 2020-04-06 | Lawrence | Indiana | 18093 | 40 | 6 |
36469 | 36469 | 2020-04-06 | Lawrence | Kentucky | 21127 | 1 | 0 |
36801 | 36801 | 2020-04-06 | Lawrence | Mississippi | 28077 | 5 | 0 |
37263 | 37263 | 2020-04-06 | Lawrence | Ohio | 39087 | 10 | 0 |
37425 | 37425 | 2020-04-06 | Lawrence | Pennsylvania | 42073 | 24 | 2 |
37526 | 37526 | 2020-04-06 | Lawrence | South Dakota | 46081 | 9 | 0 |
37586 | 37586 | 2020-04-06 | Lawrence | Tennessee | 47099 | 4 | 0 |
38123 | 38123 | 2020-04-07 | Lawrence | Alabama | 1079 | 8 | 0 |
38210 | 38210 | 2020-04-07 | Lawrence | Arkansas | 5075 | 4 | 1 |
38664 | 38664 | 2020-04-07 | Lawrence | Illinois | 17101 | 2 | 0 |
38750 | 38750 | 2020-04-07 | Lawrence | Indiana | 18093 | 45 | 6 |
38976 | 38976 | 2020-04-07 | Lawrence | Kentucky | 21127 | 1 | 0 |
39312 | 39312 | 2020-04-07 | Lawrence | Mississippi | 28077 | 5 | 0 |
39780 | 39780 | 2020-04-07 | Lawrence | Ohio | 39087 | 9 | 0 |
39948 | 39948 | 2020-04-07 | Lawrence | Pennsylvania | 42073 | 29 | 2 |
40049 | 40049 | 2020-04-07 | Lawrence | South Dakota | 46081 | 9 | 0 |
40109 | 40109 | 2020-04-07 | Lawrence | Tennessee | 47099 | 6 | 0 |
40665 | 40665 | 2020-04-08 | Lawrence | Alabama | 1079 | 8 | 0 |
40753 | 40753 | 2020-04-08 | Lawrence | Arkansas | 5075 | 8 | 1 |
41209 | 41209 | 2020-04-08 | Lawrence | Illinois | 17101 | 2 | 0 |
41296 | 41296 | 2020-04-08 | Lawrence | Indiana | 18093 | 56 | 8 |
41526 | 41526 | 2020-04-08 | Lawrence | Kentucky | 21127 | 1 | 0 |
41866 | 41866 | 2020-04-08 | Lawrence | Mississippi | 28077 | 6 | 0 |
42340 | 42340 | 2020-04-08 | Lawrence | Ohio | 39087 | 13 | 0 |
42508 | 42508 | 2020-04-08 | Lawrence | Pennsylvania | 42073 | 32 | 2 |
42609 | 42609 | 2020-04-08 | Lawrence | South Dakota | 46081 | 9 | 0 |
42671 | 42671 | 2020-04-08 | Lawrence | Tennessee | 47099 | 10 | 0 |
43238 | 43238 | 2020-04-09 | Lawrence | Alabama | 1079 | 8 | 0 |
43325 | 43325 | 2020-04-09 | Lawrence | Arkansas | 5075 | 9 | 1 |
43783 | 43783 | 2020-04-09 | Lawrence | Illinois | 17101 | 2 | 0 |
43872 | 43872 | 2020-04-09 | Lawrence | Indiana | 18093 | 57 | 8 |
44102 | 44102 | 2020-04-09 | Lawrence | Kentucky | 21127 | 1 | 0 |
44443 | 44443 | 2020-04-09 | Lawrence | Mississippi | 28077 | 8 | 0 |
44925 | 44925 | 2020-04-09 | Lawrence | Ohio | 39087 | 15 | 0 |
45094 | 45094 | 2020-04-09 | Lawrence | Pennsylvania | 42073 | 37 | 2 |
45197 | 45197 | 2020-04-09 | Lawrence | South Dakota | 46081 | 9 | 0 |
45258 | 45258 | 2020-04-09 | Lawrence | Tennessee | 47099 | 11 | 0 |
45836 | 45836 | 2020-04-10 | Lawrence | Alabama | 1079 | 8 | 0 |
45924 | 45924 | 2020-04-10 | Lawrence | Arkansas | 5075 | 10 | 1 |
46387 | 46387 | 2020-04-10 | Lawrence | Illinois | 17101 | 2 | 0 |
46476 | 46476 | 2020-04-10 | Lawrence | Indiana | 18093 | 60 | 8 |
46710 | 46710 | 2020-04-10 | Lawrence | Kentucky | 21127 | 1 | 0 |
47052 | 47052 | 2020-04-10 | Lawrence | Mississippi | 28077 | 7 | 0 |
47540 | 47540 | 2020-04-10 | Lawrence | Ohio | 39087 | 15 | 0 |
47711 | 47711 | 2020-04-10 | Lawrence | Pennsylvania | 42073 | 45 | 3 |
47814 | 47814 | 2020-04-10 | Lawrence | South Dakota | 46081 | 9 | 0 |
47876 | 47876 | 2020-04-10 | Lawrence | Tennessee | 47099 | 12 | 0 |
48465 | 48465 | 2020-04-11 | Lawrence | Alabama | 1079 | 8 | 0 |
48554 | 48554 | 2020-04-11 | Lawrence | Arkansas | 5075 | 10 | 1 |
49018 | 49018 | 2020-04-11 | Lawrence | Illinois | 17101 | 2 | 0 |
49110 | 49110 | 2020-04-11 | Lawrence | Indiana | 18093 | 64 | 8 |
49350 | 49350 | 2020-04-11 | Lawrence | Kentucky | 21127 | 1 | 0 |
49698 | 49698 | 2020-04-11 | Lawrence | Mississippi | 28077 | 6 | 0 |
50196 | 50196 | 2020-04-11 | Lawrence | Ohio | 39087 | 15 | 0 |
50368 | 50368 | 2020-04-11 | Lawrence | Pennsylvania | 42073 | 46 | 4 |
50471 | 50471 | 2020-04-11 | Lawrence | South Dakota | 46081 | 9 | 0 |
50534 | 50534 | 2020-04-11 | Lawrence | Tennessee | 47099 | 12 | 0 |
51127 | 51127 | 2020-04-12 | Lawrence | Alabama | 1079 | 8 | 0 |
51216 | 51216 | 2020-04-12 | Lawrence | Arkansas | 5075 | 11 | 1 |
51680 | 51680 | 2020-04-12 | Lawrence | Illinois | 17101 | 2 | 0 |
51773 | 51773 | 2020-04-12 | Lawrence | Indiana | 18093 | 69 | 8 |
52016 | 52016 | 2020-04-12 | Lawrence | Kentucky | 21127 | 1 | 0 |
52371 | 52371 | 2020-04-12 | Lawrence | Mississippi | 28077 | 6 | 0 |
52869 | 52869 | 2020-04-12 | Lawrence | Ohio | 39087 | 16 | 0 |
53041 | 53041 | 2020-04-12 | Lawrence | Pennsylvania | 42073 | 49 | 4 |
53144 | 53144 | 2020-04-12 | Lawrence | South Dakota | 46081 | 9 | 0 |
53209 | 53209 | 2020-04-12 | Lawrence | Tennessee | 47099 | 12 | 0 |
53805 | 53805 | 2020-04-13 | Lawrence | Alabama | 1079 | 8 | 0 |
53895 | 53895 | 2020-04-13 | Lawrence | Arkansas | 5075 | 11 | 1 |
54361 | 54361 | 2020-04-13 | Lawrence | Illinois | 17101 | 2 | 0 |
54454 | 54454 | 2020-04-13 | Lawrence | Indiana | 18093 | 72 | 8 |
54697 | 54697 | 2020-04-13 | Lawrence | Kentucky | 21127 | 1 | 0 |
55053 | 55053 | 2020-04-13 | Lawrence | Mississippi | 28077 | 6 | 0 |
55553 | 55553 | 2020-04-13 | Lawrence | Ohio | 39087 | 17 | 0 |
55726 | 55726 | 2020-04-13 | Lawrence | Pennsylvania | 42073 | 51 | 4 |
55830 | 55830 | 2020-04-13 | Lawrence | South Dakota | 46081 | 9 | 0 |
55896 | 55896 | 2020-04-13 | Lawrence | Tennessee | 47099 | 13 | 0 |
56497 | 56497 | 2020-04-14 | Lawrence | Alabama | 1079 | 8 | 0 |
56587 | 56587 | 2020-04-14 | Lawrence | Arkansas | 5075 | 11 | 1 |
57054 | 57054 | 2020-04-14 | Lawrence | Illinois | 17101 | 2 | 0 |
57147 | 57147 | 2020-04-14 | Lawrence | Indiana | 18093 | 74 | 8 |
57394 | 57394 | 2020-04-14 | Lawrence | Kentucky | 21127 | 1 | 0 |
57751 | 57751 | 2020-04-14 | Lawrence | Mississippi | 28077 | 7 | 0 |
58254 | 58254 | 2020-04-14 | Lawrence | Ohio | 39087 | 17 | 0 |
58429 | 58429 | 2020-04-14 | Lawrence | Pennsylvania | 42073 | 51 | 4 |
58533 | 58533 | 2020-04-14 | Lawrence | South Dakota | 46081 | 9 | 0 |
58599 | 58599 | 2020-04-14 | Lawrence | Tennessee | 47099 | 15 | 0 |
59205 | 59205 | 2020-04-15 | Lawrence | Alabama | 1079 | 8 | 0 |
59295 | 59295 | 2020-04-15 | Lawrence | Arkansas | 5075 | 11 | 1 |
59761 | 59761 | 2020-04-15 | Lawrence | Illinois | 17101 | 2 | 0 |
59855 | 59855 | 2020-04-15 | Lawrence | Indiana | 18093 | 74 | 10 |
60103 | 60103 | 2020-04-15 | Lawrence | Kentucky | 21127 | 1 | 0 |
60462 | 60462 | 2020-04-15 | Lawrence | Mississippi | 28077 | 7 | 0 |
60969 | 60969 | 2020-04-15 | Lawrence | Ohio | 39087 | 17 | 0 |
61144 | 61144 | 2020-04-15 | Lawrence | Pennsylvania | 42073 | 55 | 5 |
61248 | 61248 | 2020-04-15 | Lawrence | South Dakota | 46081 | 9 | 0 |
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);