ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,876 rows where county = "Houston" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Houston · 3,876 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3904 | 3904 | 2020-03-18 | Houston | Georgia | 13153 | 1 | 0 |
4577 | 4577 | 2020-03-19 | Houston | Georgia | 13153 | 1 | 0 |
5362 | 5362 | 2020-03-20 | Houston | Georgia | 13153 | 1 | 0 |
6295 | 6295 | 2020-03-21 | Houston | Georgia | 13153 | 1 | 0 |
7341 | 7341 | 2020-03-22 | Houston | Georgia | 13153 | 1 | 0 |
8055 | 8055 | 2020-03-22 | Houston | Tennessee | 47083 | 1 | 0 |
8261 | 8261 | 2020-03-23 | Houston | Alabama | 1069 | 1 | 0 |
8490 | 8490 | 2020-03-23 | Houston | Georgia | 13153 | 1 | 0 |
9273 | 9273 | 2020-03-23 | Houston | Tennessee | 47083 | 1 | 0 |
9488 | 9488 | 2020-03-24 | Houston | Alabama | 1069 | 1 | 0 |
9743 | 9743 | 2020-03-24 | Houston | Georgia | 13153 | 5 | 0 |
10604 | 10604 | 2020-03-24 | Houston | Tennessee | 47083 | 1 | 0 |
10852 | 10852 | 2020-03-25 | Houston | Alabama | 1069 | 2 | 0 |
11120 | 11120 | 2020-03-25 | Houston | Georgia | 13153 | 6 | 0 |
12082 | 12082 | 2020-03-25 | Houston | Tennessee | 47083 | 3 | 0 |
12389 | 12389 | 2020-03-26 | Houston | Alabama | 1069 | 3 | 0 |
12671 | 12671 | 2020-03-26 | Houston | Georgia | 13153 | 9 | 0 |
13706 | 13706 | 2020-03-26 | Houston | Tennessee | 47083 | 2 | 0 |
14050 | 14050 | 2020-03-27 | Houston | Alabama | 1069 | 4 | 0 |
14345 | 14345 | 2020-03-27 | Houston | Georgia | 13153 | 10 | 1 |
15458 | 15458 | 2020-03-27 | Houston | Tennessee | 47083 | 2 | 0 |
15828 | 15828 | 2020-03-28 | Houston | Alabama | 1069 | 4 | 0 |
16131 | 16131 | 2020-03-28 | Houston | Georgia | 13153 | 13 | 1 |
17320 | 17320 | 2020-03-28 | Houston | Tennessee | 47083 | 2 | 0 |
17711 | 17711 | 2020-03-29 | Houston | Alabama | 1069 | 8 | 0 |
18028 | 18028 | 2020-03-29 | Houston | Georgia | 13153 | 15 | 1 |
19268 | 19268 | 2020-03-29 | Houston | Tennessee | 47083 | 2 | 0 |
19683 | 19683 | 2020-03-30 | Houston | Alabama | 1069 | 9 | 0 |
20018 | 20018 | 2020-03-30 | Houston | Georgia | 13153 | 26 | 2 |
21323 | 21323 | 2020-03-30 | Houston | Tennessee | 47083 | 1 | 0 |
21755 | 21755 | 2020-03-31 | Houston | Alabama | 1069 | 8 | 0 |
22099 | 22099 | 2020-03-31 | Houston | Georgia | 13153 | 30 | 3 |
23461 | 23461 | 2020-03-31 | Houston | Tennessee | 47083 | 1 | 0 |
23911 | 23911 | 2020-04-01 | Houston | Alabama | 1069 | 9 | 1 |
24262 | 24262 | 2020-04-01 | Houston | Georgia | 13153 | 44 | 5 |
25662 | 25662 | 2020-04-01 | Houston | Tennessee | 47083 | 1 | 0 |
26133 | 26133 | 2020-04-02 | Houston | Alabama | 1069 | 9 | 1 |
26493 | 26493 | 2020-04-02 | Houston | Georgia | 13153 | 49 | 5 |
27940 | 27940 | 2020-04-02 | Houston | Tennessee | 47083 | 1 | 0 |
28430 | 28430 | 2020-04-03 | Houston | Alabama | 1069 | 12 | 1 |
28797 | 28797 | 2020-04-03 | Houston | Georgia | 13153 | 58 | 5 |
30275 | 30275 | 2020-04-03 | Houston | Tennessee | 47083 | 1 | 0 |
30787 | 30787 | 2020-04-04 | Houston | Alabama | 1069 | 14 | 1 |
31157 | 31157 | 2020-04-04 | Houston | Georgia | 13153 | 59 | 6 |
32666 | 32666 | 2020-04-04 | Houston | Tennessee | 47083 | 2 | 0 |
33191 | 33191 | 2020-04-05 | Houston | Alabama | 1069 | 20 | 1 |
33564 | 33564 | 2020-04-05 | Houston | Georgia | 13153 | 62 | 6 |
34264 | 34264 | 2020-04-05 | Houston | Minnesota | 27055 | 1 | 0 |
35103 | 35103 | 2020-04-05 | Houston | Tennessee | 47083 | 2 | 0 |
35630 | 35630 | 2020-04-06 | Houston | Alabama | 1069 | 24 | 1 |
36013 | 36013 | 2020-04-06 | Houston | Georgia | 13153 | 70 | 6 |
36724 | 36724 | 2020-04-06 | Houston | Minnesota | 27055 | 1 | 0 |
37579 | 37579 | 2020-04-06 | Houston | Tennessee | 47083 | 2 | 0 |
38118 | 38118 | 2020-04-07 | Houston | Alabama | 1069 | 25 | 1 |
38506 | 38506 | 2020-04-07 | Houston | Georgia | 13153 | 85 | 6 |
39233 | 39233 | 2020-04-07 | Houston | Minnesota | 27055 | 1 | 0 |
40102 | 40102 | 2020-04-07 | Houston | Tennessee | 47083 | 2 | 0 |
40660 | 40660 | 2020-04-08 | Houston | Alabama | 1069 | 27 | 1 |
41050 | 41050 | 2020-04-08 | Houston | Georgia | 13153 | 99 | 7 |
41786 | 41786 | 2020-04-08 | Houston | Minnesota | 27055 | 1 | 0 |
42664 | 42664 | 2020-04-08 | Houston | Tennessee | 47083 | 2 | 0 |
43233 | 43233 | 2020-04-09 | Houston | Alabama | 1069 | 33 | 1 |
43624 | 43624 | 2020-04-09 | Houston | Georgia | 13153 | 108 | 7 |
44362 | 44362 | 2020-04-09 | Houston | Minnesota | 27055 | 1 | 0 |
45251 | 45251 | 2020-04-09 | Houston | Tennessee | 47083 | 2 | 0 |
45831 | 45831 | 2020-04-10 | Houston | Alabama | 1069 | 33 | 1 |
46226 | 46226 | 2020-04-10 | Houston | Georgia | 13153 | 112 | 7 |
46971 | 46971 | 2020-04-10 | Houston | Minnesota | 27055 | 1 | 0 |
47869 | 47869 | 2020-04-10 | Houston | Tennessee | 47083 | 3 | 0 |
48460 | 48460 | 2020-04-11 | Houston | Alabama | 1069 | 37 | 1 |
48856 | 48856 | 2020-04-11 | Houston | Georgia | 13153 | 113 | 7 |
49616 | 49616 | 2020-04-11 | Houston | Minnesota | 27055 | 1 | 0 |
50527 | 50527 | 2020-04-11 | Houston | Tennessee | 47083 | 3 | 0 |
51122 | 51122 | 2020-04-12 | Houston | Alabama | 1069 | 44 | 1 |
51518 | 51518 | 2020-04-12 | Houston | Georgia | 13153 | 121 | 7 |
52286 | 52286 | 2020-04-12 | Houston | Minnesota | 27055 | 1 | 0 |
53202 | 53202 | 2020-04-12 | Houston | Tennessee | 47083 | 3 | 0 |
53800 | 53800 | 2020-04-13 | Houston | Alabama | 1069 | 47 | 1 |
54198 | 54198 | 2020-04-13 | Houston | Georgia | 13153 | 129 | 8 |
54968 | 54968 | 2020-04-13 | Houston | Minnesota | 27055 | 1 | 0 |
55888 | 55888 | 2020-04-13 | Houston | Tennessee | 47083 | 3 | 0 |
56492 | 56492 | 2020-04-14 | Houston | Alabama | 1069 | 52 | 2 |
56890 | 56890 | 2020-04-14 | Houston | Georgia | 13153 | 138 | 9 |
57666 | 57666 | 2020-04-14 | Houston | Minnesota | 27055 | 1 | 0 |
58591 | 58591 | 2020-04-14 | Houston | Tennessee | 47083 | 3 | 0 |
59200 | 59200 | 2020-04-15 | Houston | Alabama | 1069 | 55 | 3 |
59597 | 59597 | 2020-04-15 | Houston | Georgia | 13153 | 142 | 9 |
60376 | 60376 | 2020-04-15 | Houston | Minnesota | 27055 | 1 | 0 |
61306 | 61306 | 2020-04-15 | Houston | Tennessee | 47083 | 4 | 0 |
61918 | 61918 | 2020-04-16 | Houston | Alabama | 1069 | 58 | 3 |
62317 | 62317 | 2020-04-16 | Houston | Georgia | 13153 | 158 | 9 |
63098 | 63098 | 2020-04-16 | Houston | Minnesota | 27055 | 1 | 0 |
64033 | 64033 | 2020-04-16 | Houston | Tennessee | 47083 | 4 | 0 |
64651 | 64651 | 2020-04-17 | Houston | Alabama | 1069 | 64 | 3 |
65050 | 65050 | 2020-04-17 | Houston | Georgia | 13153 | 164 | 10 |
65837 | 65837 | 2020-04-17 | Houston | Minnesota | 27055 | 1 | 0 |
66779 | 66779 | 2020-04-17 | Houston | Tennessee | 47083 | 4 | 0 |
67399 | 67399 | 2020-04-18 | Houston | Alabama | 1069 | 63 | 2 |
67798 | 67798 | 2020-04-18 | Houston | Georgia | 13153 | 165 | 10 |
68588 | 68588 | 2020-04-18 | Houston | Minnesota | 27055 | 1 | 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);