ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,331 rows where county = "McLean" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 3
- Illinois 785
- North Dakota 777
- Kentucky 769
county 1
- McLean · 2,331 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
6351 | 6351 | 2020-03-21 | McLean | Illinois | 17113 | 6 | 0 |
7403 | 7403 | 2020-03-22 | McLean | Illinois | 17113 | 6 | 1 |
8558 | 8558 | 2020-03-23 | McLean | Illinois | 17113 | 7 | 1 |
9822 | 9822 | 2020-03-24 | McLean | Illinois | 17113 | 7 | 1 |
11214 | 11214 | 2020-03-25 | McLean | Illinois | 17113 | 7 | 1 |
12770 | 12770 | 2020-03-26 | McLean | Illinois | 17113 | 7 | 1 |
14448 | 14448 | 2020-03-27 | McLean | Illinois | 17113 | 10 | 1 |
16244 | 16244 | 2020-03-28 | McLean | Illinois | 17113 | 10 | 1 |
17025 | 17025 | 2020-03-28 | McLean | North Dakota | 38055 | 2 | 0 |
18144 | 18144 | 2020-03-29 | McLean | Illinois | 17113 | 14 | 1 |
18959 | 18959 | 2020-03-29 | McLean | North Dakota | 38055 | 2 | 0 |
20147 | 20147 | 2020-03-30 | McLean | Illinois | 17113 | 17 | 1 |
21001 | 21001 | 2020-03-30 | McLean | North Dakota | 38055 | 2 | 0 |
22239 | 22239 | 2020-03-31 | McLean | Illinois | 17113 | 19 | 2 |
23132 | 23132 | 2020-03-31 | McLean | North Dakota | 38055 | 2 | 0 |
24408 | 24408 | 2020-04-01 | McLean | Illinois | 17113 | 19 | 2 |
25327 | 25327 | 2020-04-01 | McLean | North Dakota | 38055 | 2 | 0 |
26643 | 26643 | 2020-04-02 | McLean | Illinois | 17113 | 32 | 2 |
27593 | 27593 | 2020-04-02 | McLean | North Dakota | 38055 | 2 | 0 |
28953 | 28953 | 2020-04-03 | McLean | Illinois | 17113 | 35 | 2 |
29921 | 29921 | 2020-04-03 | McLean | North Dakota | 38055 | 2 | 0 |
31318 | 31318 | 2020-04-04 | McLean | Illinois | 17113 | 40 | 2 |
32309 | 32309 | 2020-04-04 | McLean | North Dakota | 38055 | 2 | 0 |
33728 | 33728 | 2020-04-05 | McLean | Illinois | 17113 | 46 | 2 |
34025 | 34025 | 2020-04-05 | McLean | Kentucky | 21149 | 3 | 0 |
34742 | 34742 | 2020-04-05 | McLean | North Dakota | 38055 | 2 | 0 |
36180 | 36180 | 2020-04-06 | McLean | Illinois | 17113 | 46 | 2 |
36483 | 36483 | 2020-04-06 | McLean | Kentucky | 21149 | 3 | 0 |
37211 | 37211 | 2020-04-06 | McLean | North Dakota | 38055 | 2 | 0 |
38676 | 38676 | 2020-04-07 | McLean | Illinois | 17113 | 57 | 2 |
38990 | 38990 | 2020-04-07 | McLean | Kentucky | 21149 | 3 | 0 |
39728 | 39728 | 2020-04-07 | McLean | North Dakota | 38055 | 2 | 0 |
41221 | 41221 | 2020-04-08 | McLean | Illinois | 17113 | 65 | 2 |
41540 | 41540 | 2020-04-08 | McLean | Kentucky | 21149 | 3 | 0 |
42285 | 42285 | 2020-04-08 | McLean | North Dakota | 38055 | 2 | 0 |
43795 | 43795 | 2020-04-09 | McLean | Illinois | 17113 | 69 | 2 |
44116 | 44116 | 2020-04-09 | McLean | Kentucky | 21149 | 4 | 0 |
44869 | 44869 | 2020-04-09 | McLean | North Dakota | 38055 | 2 | 0 |
46399 | 46399 | 2020-04-10 | McLean | Illinois | 17113 | 75 | 2 |
46724 | 46724 | 2020-04-10 | McLean | Kentucky | 21149 | 4 | 0 |
47482 | 47482 | 2020-04-10 | McLean | North Dakota | 38055 | 2 | 0 |
49031 | 49031 | 2020-04-11 | McLean | Illinois | 17113 | 75 | 2 |
49364 | 49364 | 2020-04-11 | McLean | Kentucky | 21149 | 6 | 0 |
50137 | 50137 | 2020-04-11 | McLean | North Dakota | 38055 | 2 | 0 |
51693 | 51693 | 2020-04-12 | McLean | Illinois | 17113 | 77 | 2 |
52030 | 52030 | 2020-04-12 | McLean | Kentucky | 21149 | 5 | 0 |
52810 | 52810 | 2020-04-12 | McLean | North Dakota | 38055 | 2 | 0 |
54374 | 54374 | 2020-04-13 | McLean | Illinois | 17113 | 79 | 2 |
54711 | 54711 | 2020-04-13 | McLean | Kentucky | 21149 | 5 | 0 |
55494 | 55494 | 2020-04-13 | McLean | North Dakota | 38055 | 2 | 0 |
57067 | 57067 | 2020-04-14 | McLean | Illinois | 17113 | 81 | 2 |
57409 | 57409 | 2020-04-14 | McLean | Kentucky | 21149 | 5 | 0 |
58195 | 58195 | 2020-04-14 | McLean | North Dakota | 38055 | 2 | 0 |
59774 | 59774 | 2020-04-15 | McLean | Illinois | 17113 | 82 | 2 |
60118 | 60118 | 2020-04-15 | McLean | Kentucky | 21149 | 5 | 0 |
60909 | 60909 | 2020-04-15 | McLean | North Dakota | 38055 | 3 | 0 |
62495 | 62495 | 2020-04-16 | McLean | Illinois | 17113 | 82 | 3 |
62838 | 62838 | 2020-04-16 | McLean | Kentucky | 21149 | 6 | 0 |
63635 | 63635 | 2020-04-16 | McLean | North Dakota | 38055 | 3 | 0 |
65228 | 65228 | 2020-04-17 | McLean | Illinois | 17113 | 83 | 3 |
65577 | 65577 | 2020-04-17 | McLean | Kentucky | 21149 | 6 | 0 |
66378 | 66378 | 2020-04-17 | McLean | North Dakota | 38055 | 3 | 0 |
67977 | 67977 | 2020-04-18 | McLean | Illinois | 17113 | 83 | 3 |
68326 | 68326 | 2020-04-18 | McLean | Kentucky | 21149 | 6 | 0 |
69135 | 69135 | 2020-04-18 | McLean | North Dakota | 38055 | 3 | 0 |
70739 | 70739 | 2020-04-19 | McLean | Illinois | 17113 | 85 | 3 |
71089 | 71089 | 2020-04-19 | McLean | Kentucky | 21149 | 7 | 0 |
71901 | 71901 | 2020-04-19 | McLean | North Dakota | 38055 | 3 | 0 |
73509 | 73509 | 2020-04-20 | McLean | Illinois | 17113 | 86 | 3 |
73861 | 73861 | 2020-04-20 | McLean | Kentucky | 21149 | 7 | 0 |
74676 | 74676 | 2020-04-20 | McLean | North Dakota | 38055 | 3 | 0 |
76286 | 76286 | 2020-04-21 | McLean | Illinois | 17113 | 86 | 3 |
76642 | 76642 | 2020-04-21 | McLean | Kentucky | 21149 | 7 | 0 |
77457 | 77457 | 2020-04-21 | McLean | North Dakota | 38055 | 3 | 0 |
79070 | 79070 | 2020-04-22 | McLean | Illinois | 17113 | 86 | 3 |
79427 | 79427 | 2020-04-22 | McLean | Kentucky | 21149 | 8 | 0 |
80246 | 80246 | 2020-04-22 | McLean | North Dakota | 38055 | 3 | 0 |
81863 | 81863 | 2020-04-23 | McLean | Illinois | 17113 | 87 | 3 |
82224 | 82224 | 2020-04-23 | McLean | Kentucky | 21149 | 8 | 0 |
83045 | 83045 | 2020-04-23 | McLean | North Dakota | 38055 | 3 | 0 |
84663 | 84663 | 2020-04-24 | McLean | Illinois | 17113 | 87 | 3 |
85027 | 85027 | 2020-04-24 | McLean | Kentucky | 21149 | 9 | 0 |
85849 | 85849 | 2020-04-24 | McLean | North Dakota | 38055 | 3 | 0 |
87473 | 87473 | 2020-04-25 | McLean | Illinois | 17113 | 88 | 3 |
87836 | 87836 | 2020-04-25 | McLean | Kentucky | 21149 | 10 | 0 |
88662 | 88662 | 2020-04-25 | McLean | North Dakota | 38055 | 3 | 0 |
90289 | 90289 | 2020-04-26 | McLean | Illinois | 17113 | 88 | 3 |
90652 | 90652 | 2020-04-26 | McLean | Kentucky | 21149 | 11 | 0 |
91477 | 91477 | 2020-04-26 | McLean | North Dakota | 38055 | 3 | 0 |
93108 | 93108 | 2020-04-27 | McLean | Illinois | 17113 | 92 | 3 |
93473 | 93473 | 2020-04-27 | McLean | Kentucky | 21149 | 11 | 0 |
94303 | 94303 | 2020-04-27 | McLean | North Dakota | 38055 | 3 | 0 |
95940 | 95940 | 2020-04-28 | McLean | Illinois | 17113 | 94 | 3 |
96306 | 96306 | 2020-04-28 | McLean | Kentucky | 21149 | 11 | 0 |
97140 | 97140 | 2020-04-28 | McLean | North Dakota | 38055 | 3 | 0 |
98784 | 98784 | 2020-04-29 | McLean | Illinois | 17113 | 94 | 3 |
99152 | 99152 | 2020-04-29 | McLean | Kentucky | 21149 | 12 | 0 |
99989 | 99989 | 2020-04-29 | McLean | North Dakota | 38055 | 3 | 0 |
101635 | 101635 | 2020-04-30 | McLean | Illinois | 17113 | 95 | 3 |
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);