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)
Suggested facets: date (date)
state 11
- Mississippi 785
- Arkansas 781
- Indiana 781
- Alabama 780
- Ohio 780
- Pennsylvania 780
- South Dakota 778
- Tennessee 775
- Kentucky 774
- Illinois 767
- Missouri 741
fips 11
county 1
- Lawrence · 8,522 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5617 | 5617 | 2020-03-20 | Lawrence | Mississippi | 28077 | 1 | 0 |
6596 | 6596 | 2020-03-21 | Lawrence | Mississippi | 28077 | 1 | 0 |
7679 | 7679 | 2020-03-22 | Lawrence | Mississippi | 28077 | 2 | 0 |
8860 | 8860 | 2020-03-23 | Lawrence | Mississippi | 28077 | 2 | 0 |
9545 | 9545 | 2020-03-24 | Lawrence | Arkansas | 5075 | 1 | 0 |
9862 | 9862 | 2020-03-24 | Lawrence | Indiana | 18093 | 1 | 0 |
10156 | 10156 | 2020-03-24 | Lawrence | Mississippi | 28077 | 2 | 0 |
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
10916 | 10916 | 2020-03-25 | Lawrence | Arkansas | 5075 | 1 | 0 |
11257 | 11257 | 2020-03-25 | Lawrence | Indiana | 18093 | 1 | 0 |
11576 | 11576 | 2020-03-25 | Lawrence | Mississippi | 28077 | 3 | 0 |
11881 | 11881 | 2020-03-25 | Lawrence | Ohio | 39087 | 1 | 0 |
11978 | 11978 | 2020-03-25 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
12394 | 12394 | 2020-03-26 | Lawrence | Alabama | 1079 | 3 | 0 |
12459 | 12459 | 2020-03-26 | Lawrence | Arkansas | 5075 | 2 | 0 |
12814 | 12814 | 2020-03-26 | Lawrence | Indiana | 18093 | 2 | 0 |
13169 | 13169 | 2020-03-26 | Lawrence | Mississippi | 28077 | 5 | 0 |
13489 | 13489 | 2020-03-26 | Lawrence | Ohio | 39087 | 1 | 0 |
13599 | 13599 | 2020-03-26 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
14055 | 14055 | 2020-03-27 | Lawrence | Alabama | 1079 | 3 | 0 |
14123 | 14123 | 2020-03-27 | Lawrence | Arkansas | 5075 | 3 | 0 |
14499 | 14499 | 2020-03-27 | Lawrence | Indiana | 18093 | 5 | 0 |
14887 | 14887 | 2020-03-27 | Lawrence | Mississippi | 28077 | 5 | 0 |
15227 | 15227 | 2020-03-27 | Lawrence | Ohio | 39087 | 1 | 0 |
15345 | 15345 | 2020-03-27 | Lawrence | Pennsylvania | 42073 | 4 | 0 |
15423 | 15423 | 2020-03-27 | Lawrence | South Dakota | 46081 | 2 | 0 |
15833 | 15833 | 2020-03-28 | Lawrence | Alabama | 1079 | 3 | 0 |
15904 | 15904 | 2020-03-28 | Lawrence | Arkansas | 5075 | 1 | 0 |
16297 | 16297 | 2020-03-28 | Lawrence | Indiana | 18093 | 4 | 0 |
16711 | 16711 | 2020-03-28 | Lawrence | Mississippi | 28077 | 5 | 0 |
17069 | 17069 | 2020-03-28 | Lawrence | Ohio | 39087 | 1 | 0 |
17195 | 17195 | 2020-03-28 | Lawrence | Pennsylvania | 42073 | 8 | 0 |
17281 | 17281 | 2020-03-28 | Lawrence | South Dakota | 46081 | 2 | 0 |
17716 | 17716 | 2020-03-29 | Lawrence | Alabama | 1079 | 3 | 0 |
17791 | 17791 | 2020-03-29 | Lawrence | Arkansas | 5075 | 1 | 0 |
18201 | 18201 | 2020-03-29 | Lawrence | Indiana | 18093 | 8 | 0 |
18633 | 18633 | 2020-03-29 | Lawrence | Mississippi | 28077 | 5 | 0 |
19003 | 19003 | 2020-03-29 | Lawrence | Ohio | 39087 | 1 | 0 |
19133 | 19133 | 2020-03-29 | Lawrence | Pennsylvania | 42073 | 8 | 1 |
19224 | 19224 | 2020-03-29 | Lawrence | South Dakota | 46081 | 3 | 0 |
19688 | 19688 | 2020-03-30 | Lawrence | Alabama | 1079 | 3 | 0 |
19765 | 19765 | 2020-03-30 | Lawrence | Arkansas | 5075 | 1 | 0 |
20207 | 20207 | 2020-03-30 | Lawrence | Indiana | 18093 | 9 | 0 |
20657 | 20657 | 2020-03-30 | Lawrence | Mississippi | 28077 | 5 | 0 |
21048 | 21048 | 2020-03-30 | Lawrence | Ohio | 39087 | 1 | 0 |
21183 | 21183 | 2020-03-30 | Lawrence | Pennsylvania | 42073 | 10 | 1 |
21276 | 21276 | 2020-03-30 | Lawrence | South Dakota | 46081 | 5 | 0 |
21327 | 21327 | 2020-03-30 | Lawrence | Tennessee | 47099 | 2 | 0 |
21760 | 21760 | 2020-03-31 | Lawrence | Alabama | 1079 | 3 | 0 |
21837 | 21837 | 2020-03-31 | Lawrence | Arkansas | 5075 | 1 | 0 |
22302 | 22302 | 2020-03-31 | Lawrence | Indiana | 18093 | 9 | 0 |
22476 | 22476 | 2020-03-31 | Lawrence | Kentucky | 21127 | 1 | 0 |
22774 | 22774 | 2020-03-31 | Lawrence | Mississippi | 28077 | 5 | 0 |
23180 | 23180 | 2020-03-31 | Lawrence | Ohio | 39087 | 1 | 0 |
23319 | 23319 | 2020-03-31 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
23414 | 23414 | 2020-03-31 | Lawrence | South Dakota | 46081 | 6 | 0 |
23466 | 23466 | 2020-03-31 | Lawrence | Tennessee | 47099 | 2 | 0 |
23916 | 23916 | 2020-04-01 | Lawrence | Alabama | 1079 | 3 | 0 |
23994 | 23994 | 2020-04-01 | Lawrence | Arkansas | 5075 | 2 | 0 |
24473 | 24473 | 2020-04-01 | Lawrence | Indiana | 18093 | 11 | 1 |
24652 | 24652 | 2020-04-01 | Lawrence | Kentucky | 21127 | 1 | 0 |
24958 | 24958 | 2020-04-01 | Lawrence | Mississippi | 28077 | 5 | 0 |
25375 | 25375 | 2020-04-01 | Lawrence | Ohio | 39087 | 1 | 0 |
25517 | 25517 | 2020-04-01 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
25612 | 25612 | 2020-04-01 | Lawrence | South Dakota | 46081 | 6 | 0 |
25668 | 25668 | 2020-04-01 | Lawrence | Tennessee | 47099 | 2 | 0 |
26138 | 26138 | 2020-04-02 | Lawrence | Alabama | 1079 | 3 | 0 |
26218 | 26218 | 2020-04-02 | Lawrence | Arkansas | 5075 | 3 | 0 |
26712 | 26712 | 2020-04-02 | Lawrence | Indiana | 18093 | 13 | 2 |
26899 | 26899 | 2020-04-02 | Lawrence | Kentucky | 21127 | 1 | 0 |
27212 | 27212 | 2020-04-02 | Lawrence | Mississippi | 28077 | 5 | 0 |
27643 | 27643 | 2020-04-02 | Lawrence | Ohio | 39087 | 2 | 0 |
27790 | 27790 | 2020-04-02 | Lawrence | Pennsylvania | 42073 | 16 | 2 |
27889 | 27889 | 2020-04-02 | Lawrence | South Dakota | 46081 | 9 | 0 |
27947 | 27947 | 2020-04-02 | Lawrence | Tennessee | 47099 | 2 | 0 |
28435 | 28435 | 2020-04-03 | Lawrence | Alabama | 1079 | 4 | 0 |
28516 | 28516 | 2020-04-03 | Lawrence | Arkansas | 5075 | 3 | 0 |
29022 | 29022 | 2020-04-03 | Lawrence | Indiana | 18093 | 23 | 5 |
29215 | 29215 | 2020-04-03 | Lawrence | Kentucky | 21127 | 1 | 0 |
29531 | 29531 | 2020-04-03 | Lawrence | Mississippi | 28077 | 5 | 0 |
29972 | 29972 | 2020-04-03 | Lawrence | Ohio | 39087 | 4 | 0 |
30124 | 30124 | 2020-04-03 | Lawrence | Pennsylvania | 42073 | 19 | 2 |
30224 | 30224 | 2020-04-03 | Lawrence | South Dakota | 46081 | 9 | 0 |
30282 | 30282 | 2020-04-03 | Lawrence | Tennessee | 47099 | 3 | 0 |
30792 | 30792 | 2020-04-04 | Lawrence | Alabama | 1079 | 4 | 0 |
30874 | 30874 | 2020-04-04 | Lawrence | Arkansas | 5075 | 3 | 1 |
31388 | 31388 | 2020-04-04 | Lawrence | Indiana | 18093 | 37 | 6 |
31591 | 31591 | 2020-04-04 | Lawrence | Kentucky | 21127 | 1 | 0 |
31911 | 31911 | 2020-04-04 | Lawrence | Mississippi | 28077 | 4 | 0 |
32361 | 32361 | 2020-04-04 | Lawrence | Ohio | 39087 | 7 | 0 |
32514 | 32514 | 2020-04-04 | Lawrence | Pennsylvania | 42073 | 22 | 2 |
32615 | 32615 | 2020-04-04 | Lawrence | South Dakota | 46081 | 9 | 0 |
32673 | 32673 | 2020-04-04 | Lawrence | Tennessee | 47099 | 3 | 0 |
33196 | 33196 | 2020-04-05 | Lawrence | Alabama | 1079 | 6 | 0 |
33278 | 33278 | 2020-04-05 | Lawrence | Arkansas | 5075 | 3 | 1 |
33799 | 33799 | 2020-04-05 | Lawrence | Indiana | 18093 | 40 | 6 |
34011 | 34011 | 2020-04-05 | Lawrence | Kentucky | 21127 | 1 | 0 |
34338 | 34338 | 2020-04-05 | Lawrence | Mississippi | 28077 | 4 | 0 |
34794 | 34794 | 2020-04-05 | Lawrence | Ohio | 39087 | 8 | 0 |
34950 | 34950 | 2020-04-05 | Lawrence | Pennsylvania | 42073 | 23 | 2 |
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);