ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and fips = 42073 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
11978 | 11978 | 2020-03-25 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
13599 | 13599 | 2020-03-26 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
15345 | 15345 | 2020-03-27 | Lawrence | Pennsylvania | 42073 | 4 | 0 |
17195 | 17195 | 2020-03-28 | Lawrence | Pennsylvania | 42073 | 8 | 0 |
19133 | 19133 | 2020-03-29 | Lawrence | Pennsylvania | 42073 | 8 | 1 |
21183 | 21183 | 2020-03-30 | Lawrence | Pennsylvania | 42073 | 10 | 1 |
23319 | 23319 | 2020-03-31 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
25517 | 25517 | 2020-04-01 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
27790 | 27790 | 2020-04-02 | Lawrence | Pennsylvania | 42073 | 16 | 2 |
30124 | 30124 | 2020-04-03 | Lawrence | Pennsylvania | 42073 | 19 | 2 |
32514 | 32514 | 2020-04-04 | Lawrence | Pennsylvania | 42073 | 22 | 2 |
34950 | 34950 | 2020-04-05 | Lawrence | Pennsylvania | 42073 | 23 | 2 |
37425 | 37425 | 2020-04-06 | Lawrence | Pennsylvania | 42073 | 24 | 2 |
39948 | 39948 | 2020-04-07 | Lawrence | Pennsylvania | 42073 | 29 | 2 |
42508 | 42508 | 2020-04-08 | Lawrence | Pennsylvania | 42073 | 32 | 2 |
45094 | 45094 | 2020-04-09 | Lawrence | Pennsylvania | 42073 | 37 | 2 |
47711 | 47711 | 2020-04-10 | Lawrence | Pennsylvania | 42073 | 45 | 3 |
50368 | 50368 | 2020-04-11 | Lawrence | Pennsylvania | 42073 | 46 | 4 |
53041 | 53041 | 2020-04-12 | Lawrence | Pennsylvania | 42073 | 49 | 4 |
55726 | 55726 | 2020-04-13 | Lawrence | Pennsylvania | 42073 | 51 | 4 |
58429 | 58429 | 2020-04-14 | Lawrence | Pennsylvania | 42073 | 51 | 4 |
61144 | 61144 | 2020-04-15 | Lawrence | Pennsylvania | 42073 | 55 | 5 |
63870 | 63870 | 2020-04-16 | Lawrence | Pennsylvania | 42073 | 55 | 5 |
66616 | 66616 | 2020-04-17 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
69374 | 69374 | 2020-04-18 | Lawrence | Pennsylvania | 42073 | 60 | 5 |
72141 | 72141 | 2020-04-19 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
74916 | 74916 | 2020-04-20 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
77698 | 77698 | 2020-04-21 | Lawrence | Pennsylvania | 42073 | 60 | 6 |
80488 | 80488 | 2020-04-22 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
83287 | 83287 | 2020-04-23 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
86091 | 86091 | 2020-04-24 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
88905 | 88905 | 2020-04-25 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
91721 | 91721 | 2020-04-26 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
94548 | 94548 | 2020-04-27 | Lawrence | Pennsylvania | 42073 | 63 | 6 |
97387 | 97387 | 2020-04-28 | Lawrence | Pennsylvania | 42073 | 63 | 6 |
100236 | 100236 | 2020-04-29 | Lawrence | Pennsylvania | 42073 | 64 | 6 |
103089 | 103089 | 2020-04-30 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
105952 | 105952 | 2020-05-01 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
108819 | 108819 | 2020-05-02 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
111693 | 111693 | 2020-05-03 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
114575 | 114575 | 2020-05-04 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
117456 | 117456 | 2020-05-05 | Lawrence | Pennsylvania | 42073 | 67 | 7 |
120418 | 120418 | 2020-05-06 | Lawrence | Pennsylvania | 42073 | 68 | 7 |
123395 | 123395 | 2020-05-07 | Lawrence | Pennsylvania | 42073 | 69 | 7 |
126378 | 126378 | 2020-05-08 | Lawrence | Pennsylvania | 42073 | 69 | 7 |
129367 | 129367 | 2020-05-09 | Lawrence | Pennsylvania | 42073 | 69 | 7 |
132356 | 132356 | 2020-05-10 | Lawrence | Pennsylvania | 42073 | 70 | 7 |
135347 | 135347 | 2020-05-11 | Lawrence | Pennsylvania | 42073 | 70 | 7 |
138337 | 138337 | 2020-05-12 | Lawrence | Pennsylvania | 42073 | 71 | 7 |
141333 | 141333 | 2020-05-13 | Lawrence | Pennsylvania | 42073 | 71 | 7 |
144329 | 144329 | 2020-05-14 | Lawrence | Pennsylvania | 42073 | 71 | 7 |
147330 | 147330 | 2020-05-15 | Lawrence | Pennsylvania | 42073 | 72 | 7 |
150337 | 150337 | 2020-05-16 | Lawrence | Pennsylvania | 42073 | 72 | 7 |
153348 | 153348 | 2020-05-17 | Lawrence | Pennsylvania | 42073 | 72 | 7 |
156365 | 156365 | 2020-05-18 | Lawrence | Pennsylvania | 42073 | 72 | 8 |
159386 | 159386 | 2020-05-19 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
162413 | 162413 | 2020-05-20 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
165442 | 165442 | 2020-05-21 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
168478 | 168478 | 2020-05-22 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
171517 | 171517 | 2020-05-23 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
174559 | 174559 | 2020-05-24 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
177603 | 177603 | 2020-05-25 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
180646 | 180646 | 2020-05-26 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
183696 | 183696 | 2020-05-27 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
186753 | 186753 | 2020-05-28 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
189814 | 189814 | 2020-05-29 | Lawrence | Pennsylvania | 42073 | 76 | 8 |
192879 | 192879 | 2020-05-30 | Lawrence | Pennsylvania | 42073 | 79 | 8 |
195948 | 195948 | 2020-05-31 | Lawrence | Pennsylvania | 42073 | 80 | 8 |
199021 | 199021 | 2020-06-01 | Lawrence | Pennsylvania | 42073 | 80 | 8 |
202096 | 202096 | 2020-06-02 | Lawrence | Pennsylvania | 42073 | 81 | 8 |
205173 | 205173 | 2020-06-03 | Lawrence | Pennsylvania | 42073 | 83 | 8 |
208254 | 208254 | 2020-06-04 | Lawrence | Pennsylvania | 42073 | 82 | 8 |
211336 | 211336 | 2020-06-05 | Lawrence | Pennsylvania | 42073 | 82 | 8 |
214422 | 214422 | 2020-06-06 | Lawrence | Pennsylvania | 42073 | 84 | 8 |
217512 | 217512 | 2020-06-07 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
220604 | 220604 | 2020-06-08 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
223699 | 223699 | 2020-06-09 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
226799 | 226799 | 2020-06-10 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
229903 | 229903 | 2020-06-11 | Lawrence | Pennsylvania | 42073 | 86 | 8 |
233008 | 233008 | 2020-06-12 | Lawrence | Pennsylvania | 42073 | 86 | 8 |
236113 | 236113 | 2020-06-13 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
239221 | 239221 | 2020-06-14 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
242330 | 242330 | 2020-06-15 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
245442 | 245442 | 2020-06-16 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
248555 | 248555 | 2020-06-17 | Lawrence | Pennsylvania | 42073 | 88 | 8 |
251670 | 251670 | 2020-06-18 | Lawrence | Pennsylvania | 42073 | 89 | 8 |
254785 | 254785 | 2020-06-19 | Lawrence | Pennsylvania | 42073 | 90 | 9 |
257911 | 257911 | 2020-06-20 | Lawrence | Pennsylvania | 42073 | 90 | 9 |
261038 | 261038 | 2020-06-21 | Lawrence | Pennsylvania | 42073 | 90 | 9 |
264166 | 264166 | 2020-06-22 | Lawrence | Pennsylvania | 42073 | 92 | 9 |
267294 | 267294 | 2020-06-23 | Lawrence | Pennsylvania | 42073 | 92 | 9 |
270428 | 270428 | 2020-06-24 | Lawrence | Pennsylvania | 42073 | 94 | 9 |
273567 | 273567 | 2020-06-25 | Lawrence | Pennsylvania | 42073 | 99 | 9 |
276714 | 276714 | 2020-06-26 | Lawrence | Pennsylvania | 42073 | 99 | 9 |
279862 | 279862 | 2020-06-27 | Lawrence | Pennsylvania | 42073 | 101 | 9 |
283008 | 283008 | 2020-06-28 | Lawrence | Pennsylvania | 42073 | 102 | 9 |
286153 | 286153 | 2020-06-29 | Lawrence | Pennsylvania | 42073 | 101 | 9 |
289304 | 289304 | 2020-06-30 | Lawrence | Pennsylvania | 42073 | 102 | 9 |
292456 | 292456 | 2020-07-01 | Lawrence | Pennsylvania | 42073 | 103 | 9 |
295612 | 295612 | 2020-07-02 | Lawrence | Pennsylvania | 42073 | 107 | 9 |
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);