ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "LaSalle" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3931 | 3931 | 2020-03-18 | LaSalle | Illinois | 17099 | 1 | 0 |
4607 | 4607 | 2020-03-19 | LaSalle | Illinois | 17099 | 1 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
6347 | 6347 | 2020-03-21 | LaSalle | Illinois | 17099 | 1 | 0 |
7398 | 7398 | 2020-03-22 | LaSalle | Illinois | 17099 | 1 | 0 |
8553 | 8553 | 2020-03-23 | LaSalle | Illinois | 17099 | 2 | 0 |
9817 | 9817 | 2020-03-24 | LaSalle | Illinois | 17099 | 3 | 0 |
11208 | 11208 | 2020-03-25 | LaSalle | Illinois | 17099 | 3 | 0 |
12764 | 12764 | 2020-03-26 | LaSalle | Illinois | 17099 | 3 | 0 |
12971 | 12971 | 2020-03-26 | LaSalle | Louisiana | 22059 | 1 | 0 |
14442 | 14442 | 2020-03-27 | LaSalle | Illinois | 17099 | 3 | 0 |
14678 | 14678 | 2020-03-27 | LaSalle | Louisiana | 22059 | 1 | 0 |
16237 | 16237 | 2020-03-28 | LaSalle | Illinois | 17099 | 4 | 1 |
16498 | 16498 | 2020-03-28 | LaSalle | Louisiana | 22059 | 2 | 0 |
18137 | 18137 | 2020-03-29 | LaSalle | Illinois | 17099 | 4 | 2 |
18410 | 18410 | 2020-03-29 | LaSalle | Louisiana | 22059 | 2 | 0 |
20139 | 20139 | 2020-03-30 | LaSalle | Illinois | 17099 | 5 | 2 |
20426 | 20426 | 2020-03-30 | LaSalle | Louisiana | 22059 | 2 | 0 |
22231 | 22231 | 2020-03-31 | LaSalle | Illinois | 17099 | 6 | 1 |
22534 | 22534 | 2020-03-31 | LaSalle | Louisiana | 22059 | 2 | 0 |
24399 | 24399 | 2020-04-01 | LaSalle | Illinois | 17099 | 6 | 1 |
24710 | 24710 | 2020-04-01 | LaSalle | Louisiana | 22059 | 2 | 0 |
26632 | 26632 | 2020-04-02 | LaSalle | Illinois | 17099 | 6 | 1 |
26961 | 26961 | 2020-04-02 | LaSalle | Louisiana | 22059 | 2 | 0 |
28942 | 28942 | 2020-04-03 | LaSalle | Illinois | 17099 | 6 | 1 |
29278 | 29278 | 2020-04-03 | LaSalle | Louisiana | 22059 | 2 | 0 |
31305 | 31305 | 2020-04-04 | LaSalle | Illinois | 17099 | 7 | 1 |
31656 | 31656 | 2020-04-04 | LaSalle | Louisiana | 22059 | 4 | 0 |
33715 | 33715 | 2020-04-05 | LaSalle | Illinois | 17099 | 8 | 1 |
34081 | 34081 | 2020-04-05 | LaSalle | Louisiana | 22059 | 4 | 0 |
36167 | 36167 | 2020-04-06 | LaSalle | Illinois | 17099 | 11 | 1 |
36539 | 36539 | 2020-04-06 | LaSalle | Louisiana | 22059 | 6 | 0 |
38662 | 38662 | 2020-04-07 | LaSalle | Illinois | 17099 | 15 | 1 |
39047 | 39047 | 2020-04-07 | LaSalle | Louisiana | 22059 | 6 | 0 |
41207 | 41207 | 2020-04-08 | LaSalle | Illinois | 17099 | 17 | 1 |
41599 | 41599 | 2020-04-08 | LaSalle | Louisiana | 22059 | 8 | 0 |
43781 | 43781 | 2020-04-09 | LaSalle | Illinois | 17099 | 17 | 1 |
44175 | 44175 | 2020-04-09 | LaSalle | Louisiana | 22059 | 9 | 0 |
46385 | 46385 | 2020-04-10 | LaSalle | Illinois | 17099 | 19 | 1 |
46783 | 46783 | 2020-04-10 | LaSalle | Louisiana | 22059 | 9 | 0 |
49016 | 49016 | 2020-04-11 | LaSalle | Illinois | 17099 | 18 | 1 |
49424 | 49424 | 2020-04-11 | LaSalle | Louisiana | 22059 | 10 | 0 |
51678 | 51678 | 2020-04-12 | LaSalle | Illinois | 17099 | 20 | 1 |
52094 | 52094 | 2020-04-12 | LaSalle | Louisiana | 22059 | 11 | 0 |
54359 | 54359 | 2020-04-13 | LaSalle | Illinois | 17099 | 21 | 1 |
54775 | 54775 | 2020-04-13 | LaSalle | Louisiana | 22059 | 13 | 0 |
57052 | 57052 | 2020-04-14 | LaSalle | Illinois | 17099 | 23 | 1 |
57473 | 57473 | 2020-04-14 | LaSalle | Louisiana | 22059 | 13 | 0 |
59759 | 59759 | 2020-04-15 | LaSalle | Illinois | 17099 | 24 | 1 |
60181 | 60181 | 2020-04-15 | LaSalle | Louisiana | 22059 | 13 | 0 |
62480 | 62480 | 2020-04-16 | LaSalle | Illinois | 17099 | 25 | 1 |
62902 | 62902 | 2020-04-16 | LaSalle | Louisiana | 22059 | 13 | 0 |
65213 | 65213 | 2020-04-17 | LaSalle | Illinois | 17099 | 27 | 1 |
65641 | 65641 | 2020-04-17 | LaSalle | Louisiana | 22059 | 13 | 0 |
67962 | 67962 | 2020-04-18 | LaSalle | Illinois | 17099 | 27 | 1 |
68390 | 68390 | 2020-04-18 | LaSalle | Louisiana | 22059 | 13 | 0 |
70724 | 70724 | 2020-04-19 | LaSalle | Illinois | 17099 | 28 | 1 |
71153 | 71153 | 2020-04-19 | LaSalle | Louisiana | 22059 | 13 | 0 |
73494 | 73494 | 2020-04-20 | LaSalle | Illinois | 17099 | 30 | 1 |
73925 | 73925 | 2020-04-20 | LaSalle | Louisiana | 22059 | 14 | 0 |
76271 | 76271 | 2020-04-21 | LaSalle | Illinois | 17099 | 33 | 1 |
76705 | 76705 | 2020-04-21 | LaSalle | Louisiana | 22059 | 14 | 0 |
79055 | 79055 | 2020-04-22 | LaSalle | Illinois | 17099 | 38 | 1 |
79491 | 79491 | 2020-04-22 | LaSalle | Louisiana | 22059 | 15 | 0 |
81848 | 81848 | 2020-04-23 | LaSalle | Illinois | 17099 | 39 | 1 |
82287 | 82287 | 2020-04-23 | LaSalle | Louisiana | 22059 | 15 | 0 |
84648 | 84648 | 2020-04-24 | LaSalle | Illinois | 17099 | 42 | 1 |
85091 | 85091 | 2020-04-24 | LaSalle | Louisiana | 22059 | 17 | 0 |
87458 | 87458 | 2020-04-25 | LaSalle | Illinois | 17099 | 43 | 1 |
87900 | 87900 | 2020-04-25 | LaSalle | Louisiana | 22059 | 18 | 0 |
90274 | 90274 | 2020-04-26 | LaSalle | Illinois | 17099 | 44 | 1 |
90716 | 90716 | 2020-04-26 | LaSalle | Louisiana | 22059 | 19 | 0 |
93093 | 93093 | 2020-04-27 | LaSalle | Illinois | 17099 | 46 | 1 |
93537 | 93537 | 2020-04-27 | LaSalle | Louisiana | 22059 | 21 | 0 |
95925 | 95925 | 2020-04-28 | LaSalle | Illinois | 17099 | 49 | 1 |
96372 | 96372 | 2020-04-28 | LaSalle | Louisiana | 22059 | 21 | 0 |
98769 | 98769 | 2020-04-29 | LaSalle | Illinois | 17099 | 49 | 1 |
99218 | 99218 | 2020-04-29 | LaSalle | Louisiana | 22059 | 22 | 0 |
101620 | 101620 | 2020-04-30 | LaSalle | Illinois | 17099 | 53 | 1 |
102070 | 102070 | 2020-04-30 | LaSalle | Louisiana | 22059 | 23 | 0 |
104476 | 104476 | 2020-05-01 | LaSalle | Illinois | 17099 | 54 | 1 |
104931 | 104931 | 2020-05-01 | LaSalle | Louisiana | 22059 | 26 | 0 |
107341 | 107341 | 2020-05-02 | LaSalle | Illinois | 17099 | 65 | 1 |
107795 | 107795 | 2020-05-02 | LaSalle | Louisiana | 22059 | 26 | 0 |
110211 | 110211 | 2020-05-03 | LaSalle | Illinois | 17099 | 67 | 1 |
110667 | 110667 | 2020-05-03 | LaSalle | Louisiana | 22059 | 26 | 0 |
113086 | 113086 | 2020-05-04 | LaSalle | Illinois | 17099 | 70 | 1 |
113544 | 113544 | 2020-05-04 | LaSalle | Louisiana | 22059 | 27 | 0 |
115969 | 115969 | 2020-05-05 | LaSalle | Illinois | 17099 | 69 | 1 |
116426 | 116426 | 2020-05-05 | LaSalle | Louisiana | 22059 | 27 | 0 |
118929 | 118929 | 2020-05-06 | LaSalle | Illinois | 17099 | 84 | 2 |
119387 | 119387 | 2020-05-06 | LaSalle | Louisiana | 22059 | 29 | 0 |
121899 | 121899 | 2020-05-07 | LaSalle | Illinois | 17099 | 91 | 2 |
122358 | 122358 | 2020-05-07 | LaSalle | Louisiana | 22059 | 30 | 0 |
124878 | 124878 | 2020-05-08 | LaSalle | Illinois | 17099 | 93 | 3 |
125340 | 125340 | 2020-05-08 | LaSalle | Louisiana | 22059 | 31 | 0 |
127865 | 127865 | 2020-05-09 | LaSalle | Illinois | 17099 | 102 | 5 |
128327 | 128327 | 2020-05-09 | LaSalle | Louisiana | 22059 | 33 | 0 |
130856 | 130856 | 2020-05-10 | LaSalle | Illinois | 17099 | 105 | 5 |
131317 | 131317 | 2020-05-10 | LaSalle | Louisiana | 22059 | 33 | 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);