ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,322 rows where county = "Lee" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Florida 793
- Alabama 788
- Georgia 786
- Mississippi 784
- South Carolina 779
- Virginia 779
- North Carolina 778
- Texas 771
- Illinois 770
- Arkansas 769
- Iowa 761
- Kentucky 664
fips 12
county 1
- Lee · 9,222 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
13651 | 13651 | 2020-03-26 | Lee | South Carolina | 45061 | 2 | 0 |
13889 | 13889 | 2020-03-26 | Lee | Virginia | 51105 | 2 | 0 |
15154 | 15154 | 2020-03-27 | Lee | North Carolina | 37105 | 2 | 0 |
15398 | 15398 | 2020-03-27 | Lee | South Carolina | 45061 | 2 | 0 |
15657 | 15657 | 2020-03-27 | Lee | Virginia | 51105 | 2 | 0 |
16986 | 16986 | 2020-03-28 | Lee | North Carolina | 37105 | 2 | 0 |
17533 | 17533 | 2020-03-28 | Lee | Virginia | 51105 | 2 | 0 |
18917 | 18917 | 2020-03-29 | Lee | North Carolina | 37105 | 2 | 0 |
19494 | 19494 | 2020-03-29 | Lee | Virginia | 51105 | 2 | 0 |
20957 | 20957 | 2020-03-30 | Lee | North Carolina | 37105 | 2 | 0 |
21559 | 21559 | 2020-03-30 | Lee | Virginia | 51105 | 2 | 0 |
23083 | 23083 | 2020-03-31 | Lee | North Carolina | 37105 | 2 | 0 |
23705 | 23705 | 2020-03-31 | Lee | Virginia | 51105 | 2 | 0 |
25921 | 25921 | 2020-04-01 | Lee | Virginia | 51105 | 2 | 0 |
28211 | 28211 | 2020-04-02 | Lee | Virginia | 51105 | 2 | 0 |
30405 | 30405 | 2020-04-03 | Lee | Texas | 48287 | 2 | 0 |
30557 | 30557 | 2020-04-03 | Lee | Virginia | 51105 | 2 | 0 |
31307 | 31307 | 2020-04-04 | Lee | Illinois | 17103 | 2 | 0 |
32800 | 32800 | 2020-04-04 | Lee | Texas | 48287 | 2 | 0 |
32956 | 32956 | 2020-04-04 | Lee | Virginia | 51105 | 2 | 0 |
33279 | 33279 | 2020-04-05 | Lee | Arkansas | 5077 | 2 | 0 |
33717 | 33717 | 2020-04-05 | Lee | Illinois | 17103 | 2 | 0 |
35238 | 35238 | 2020-04-05 | Lee | Texas | 48287 | 2 | 0 |
35394 | 35394 | 2020-04-05 | Lee | Virginia | 51105 | 2 | 0 |
35722 | 35722 | 2020-04-06 | Lee | Arkansas | 5077 | 2 | 0 |
36169 | 36169 | 2020-04-06 | Lee | Illinois | 17103 | 2 | 0 |
37714 | 37714 | 2020-04-06 | Lee | Texas | 48287 | 2 | 0 |
37877 | 37877 | 2020-04-06 | Lee | Virginia | 51105 | 2 | 0 |
38211 | 38211 | 2020-04-07 | Lee | Arkansas | 5077 | 2 | 0 |
40242 | 40242 | 2020-04-07 | Lee | Texas | 48287 | 2 | 0 |
40410 | 40410 | 2020-04-07 | Lee | Virginia | 51105 | 2 | 0 |
40754 | 40754 | 2020-04-08 | Lee | Arkansas | 5077 | 2 | 0 |
42810 | 42810 | 2020-04-08 | Lee | Texas | 48287 | 2 | 0 |
43326 | 43326 | 2020-04-09 | Lee | Arkansas | 5077 | 2 | 0 |
45400 | 45400 | 2020-04-09 | Lee | Texas | 48287 | 2 | 0 |
45925 | 45925 | 2020-04-10 | Lee | Arkansas | 5077 | 2 | 0 |
48021 | 48021 | 2020-04-10 | Lee | Texas | 48287 | 2 | 0 |
48555 | 48555 | 2020-04-11 | Lee | Arkansas | 5077 | 2 | 0 |
50679 | 50679 | 2020-04-11 | Lee | Texas | 48287 | 2 | 0 |
51217 | 51217 | 2020-04-12 | Lee | Arkansas | 5077 | 2 | 0 |
53354 | 53354 | 2020-04-12 | Lee | Texas | 48287 | 2 | 0 |
53896 | 53896 | 2020-04-13 | Lee | Arkansas | 5077 | 2 | 0 |
54545 | 54545 | 2020-04-13 | Lee | Iowa | 19111 | 2 | 0 |
56042 | 56042 | 2020-04-13 | Lee | Texas | 48287 | 2 | 0 |
56588 | 56588 | 2020-04-14 | Lee | Arkansas | 5077 | 2 | 1 |
57238 | 57238 | 2020-04-14 | Lee | Iowa | 19111 | 2 | 0 |
58747 | 58747 | 2020-04-14 | Lee | Texas | 48287 | 2 | 0 |
59946 | 59946 | 2020-04-15 | Lee | Iowa | 19111 | 2 | 0 |
61465 | 61465 | 2020-04-15 | Lee | Texas | 48287 | 2 | 0 |
64193 | 64193 | 2020-04-16 | Lee | Texas | 48287 | 2 | 0 |
66940 | 66940 | 2020-04-17 | Lee | Texas | 48287 | 2 | 0 |
69700 | 69700 | 2020-04-18 | Lee | Texas | 48287 | 2 | 0 |
72469 | 72469 | 2020-04-19 | Lee | Texas | 48287 | 2 | 0 |
75245 | 75245 | 2020-04-20 | Lee | Texas | 48287 | 2 | 0 |
78027 | 78027 | 2020-04-21 | Lee | Texas | 48287 | 2 | 0 |
80818 | 80818 | 2020-04-22 | Lee | Texas | 48287 | 2 | 0 |
83619 | 83619 | 2020-04-23 | Lee | Texas | 48287 | 2 | 0 |
86424 | 86424 | 2020-04-24 | Lee | Texas | 48287 | 2 | 0 |
89239 | 89239 | 2020-04-25 | Lee | Texas | 48287 | 2 | 0 |
92056 | 92056 | 2020-04-26 | Lee | Texas | 48287 | 2 | 0 |
94885 | 94885 | 2020-04-27 | Lee | Texas | 48287 | 2 | 0 |
97725 | 97725 | 2020-04-28 | Lee | Texas | 48287 | 2 | 0 |
100575 | 100575 | 2020-04-29 | Lee | Texas | 48287 | 2 | 0 |
103430 | 103430 | 2020-04-30 | Lee | Texas | 48287 | 2 | 0 |
106294 | 106294 | 2020-05-01 | Lee | Texas | 48287 | 2 | 0 |
109163 | 109163 | 2020-05-02 | Lee | Texas | 48287 | 2 | 0 |
112037 | 112037 | 2020-05-03 | Lee | Texas | 48287 | 2 | 0 |
114919 | 114919 | 2020-05-04 | Lee | Texas | 48287 | 2 | 0 |
117878 | 117878 | 2020-05-05 | Lee | Texas | 48287 | 2 | 0 |
120842 | 120842 | 2020-05-06 | Lee | Texas | 48287 | 2 | 0 |
123821 | 123821 | 2020-05-07 | Lee | Texas | 48287 | 2 | 0 |
348484 | 348484 | 2020-07-19 | Lee | Kentucky | 21129 | 2 | 0 |
3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
25277 | 25277 | 2020-04-01 | Lee | North Carolina | 37105 | 3 | 0 |
27540 | 27540 | 2020-04-02 | Lee | North Carolina | 37105 | 3 | 0 |
29867 | 29867 | 2020-04-03 | Lee | North Carolina | 37105 | 3 | 0 |
32254 | 32254 | 2020-04-04 | Lee | North Carolina | 37105 | 3 | 0 |
34685 | 34685 | 2020-04-05 | Lee | North Carolina | 37105 | 3 | 0 |
37154 | 37154 | 2020-04-06 | Lee | North Carolina | 37105 | 3 | 0 |
38665 | 38665 | 2020-04-07 | Lee | Illinois | 17103 | 3 | 0 |
42979 | 42979 | 2020-04-08 | Lee | Virginia | 51105 | 3 | 0 |
45574 | 45574 | 2020-04-09 | Lee | Virginia | 51105 | 3 | 0 |
48200 | 48200 | 2020-04-10 | Lee | Virginia | 51105 | 3 | 0 |
59296 | 59296 | 2020-04-15 | Lee | Arkansas | 5077 | 3 | 1 |
62015 | 62015 | 2020-04-16 | Lee | Arkansas | 5077 | 3 | 1 |
62667 | 62667 | 2020-04-16 | Lee | Iowa | 19111 | 3 | 0 |
64748 | 64748 | 2020-04-17 | Lee | Arkansas | 5077 | 3 | 1 |
65401 | 65401 | 2020-04-17 | Lee | Iowa | 19111 | 3 | 0 |
67496 | 67496 | 2020-04-18 | Lee | Arkansas | 5077 | 3 | 1 |
68150 | 68150 | 2020-04-18 | Lee | Iowa | 19111 | 3 | 0 |
70258 | 70258 | 2020-04-19 | Lee | Arkansas | 5077 | 3 | 1 |
70912 | 70912 | 2020-04-19 | Lee | Iowa | 19111 | 3 | 0 |
73027 | 73027 | 2020-04-20 | Lee | Arkansas | 5077 | 3 | 1 |
73683 | 73683 | 2020-04-20 | Lee | Iowa | 19111 | 3 | 0 |
75803 | 75803 | 2020-04-21 | Lee | Arkansas | 5077 | 3 | 1 |
76462 | 76462 | 2020-04-21 | Lee | Iowa | 19111 | 3 | 0 |
78587 | 78587 | 2020-04-22 | Lee | Arkansas | 5077 | 3 | 1 |
79246 | 79246 | 2020-04-22 | Lee | Iowa | 19111 | 3 | 0 |
81381 | 81381 | 2020-04-23 | Lee | Arkansas | 5077 | 3 | 1 |
82039 | 82039 | 2020-04-23 | Lee | Iowa | 19111 | 3 | 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);