ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,676 rows where county = "Newton" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Newton · 4,676 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421 | 2421 | 2020-03-15 | Newton | Georgia | 13217 | 1 | 0 |
2860 | 2860 | 2020-03-16 | Newton | Georgia | 13217 | 1 | 0 |
3345 | 3345 | 2020-03-17 | Newton | Georgia | 13217 | 1 | 0 |
3907 | 3907 | 2020-03-18 | Newton | Georgia | 13217 | 3 | 0 |
4581 | 4581 | 2020-03-19 | Newton | Georgia | 13217 | 3 | 0 |
5371 | 5371 | 2020-03-20 | Newton | Georgia | 13217 | 4 | 0 |
6305 | 6305 | 2020-03-21 | Newton | Georgia | 13217 | 4 | 0 |
7351 | 7351 | 2020-03-22 | Newton | Georgia | 13217 | 4 | 0 |
8503 | 8503 | 2020-03-23 | Newton | Georgia | 13217 | 4 | 0 |
9761 | 9761 | 2020-03-24 | Newton | Georgia | 13217 | 6 | 0 |
10167 | 10167 | 2020-03-24 | Newton | Mississippi | 28101 | 1 | 0 |
11141 | 11141 | 2020-03-25 | Newton | Georgia | 13217 | 8 | 0 |
11587 | 11587 | 2020-03-25 | Newton | Mississippi | 28101 | 1 | 0 |
11637 | 11637 | 2020-03-25 | Newton | Missouri | 29145 | 1 | 0 |
12693 | 12693 | 2020-03-26 | Newton | Georgia | 13217 | 12 | 0 |
13180 | 13180 | 2020-03-26 | Newton | Mississippi | 28101 | 1 | 0 |
13235 | 13235 | 2020-03-26 | Newton | Missouri | 29145 | 3 | 0 |
14367 | 14367 | 2020-03-27 | Newton | Georgia | 13217 | 15 | 0 |
14899 | 14899 | 2020-03-27 | Newton | Mississippi | 28101 | 1 | 0 |
14961 | 14961 | 2020-03-27 | Newton | Missouri | 29145 | 3 | 0 |
16155 | 16155 | 2020-03-28 | Newton | Georgia | 13217 | 15 | 0 |
16305 | 16305 | 2020-03-28 | Newton | Indiana | 18111 | 1 | 0 |
16723 | 16723 | 2020-03-28 | Newton | Mississippi | 28101 | 1 | 0 |
16785 | 16785 | 2020-03-28 | Newton | Missouri | 29145 | 4 | 0 |
18052 | 18052 | 2020-03-29 | Newton | Georgia | 13217 | 18 | 0 |
18209 | 18209 | 2020-03-29 | Newton | Indiana | 18111 | 1 | 0 |
18645 | 18645 | 2020-03-29 | Newton | Mississippi | 28101 | 1 | 0 |
18707 | 18707 | 2020-03-29 | Newton | Missouri | 29145 | 4 | 0 |
19769 | 19769 | 2020-03-30 | Newton | Arkansas | 5101 | 1 | 0 |
20045 | 20045 | 2020-03-30 | Newton | Georgia | 13217 | 22 | 0 |
20215 | 20215 | 2020-03-30 | Newton | Indiana | 18111 | 1 | 0 |
20669 | 20669 | 2020-03-30 | Newton | Mississippi | 28101 | 2 | 0 |
20737 | 20737 | 2020-03-30 | Newton | Missouri | 29145 | 4 | 0 |
21842 | 21842 | 2020-03-31 | Newton | Arkansas | 5101 | 1 | 0 |
22126 | 22126 | 2020-03-31 | Newton | Georgia | 13217 | 31 | 0 |
22310 | 22310 | 2020-03-31 | Newton | Indiana | 18111 | 1 | 0 |
22786 | 22786 | 2020-03-31 | Newton | Mississippi | 28101 | 2 | 0 |
22856 | 22856 | 2020-03-31 | Newton | Missouri | 29145 | 5 | 0 |
24000 | 24000 | 2020-04-01 | Newton | Arkansas | 5101 | 1 | 0 |
24290 | 24290 | 2020-04-01 | Newton | Georgia | 13217 | 34 | 0 |
24481 | 24481 | 2020-04-01 | Newton | Indiana | 18111 | 1 | 0 |
24970 | 24970 | 2020-04-01 | Newton | Mississippi | 28101 | 2 | 0 |
25044 | 25044 | 2020-04-01 | Newton | Missouri | 29145 | 5 | 0 |
25804 | 25804 | 2020-04-01 | Newton | Texas | 48351 | 1 | 0 |
26226 | 26226 | 2020-04-02 | Newton | Arkansas | 5101 | 1 | 0 |
26521 | 26521 | 2020-04-02 | Newton | Georgia | 13217 | 37 | 0 |
26720 | 26720 | 2020-04-02 | Newton | Indiana | 18111 | 1 | 0 |
27224 | 27224 | 2020-04-02 | Newton | Mississippi | 28101 | 4 | 0 |
27301 | 27301 | 2020-04-02 | Newton | Missouri | 29145 | 6 | 0 |
28090 | 28090 | 2020-04-02 | Newton | Texas | 48351 | 1 | 0 |
28524 | 28524 | 2020-04-03 | Newton | Arkansas | 5101 | 1 | 0 |
28826 | 28826 | 2020-04-03 | Newton | Georgia | 13217 | 42 | 1 |
29030 | 29030 | 2020-04-03 | Newton | Indiana | 18111 | 1 | 0 |
29543 | 29543 | 2020-04-03 | Newton | Mississippi | 28101 | 4 | 0 |
29622 | 29622 | 2020-04-03 | Newton | Missouri | 29145 | 6 | 0 |
30426 | 30426 | 2020-04-03 | Newton | Texas | 48351 | 1 | 0 |
30882 | 30882 | 2020-04-04 | Newton | Arkansas | 5101 | 1 | 0 |
31186 | 31186 | 2020-04-04 | Newton | Georgia | 13217 | 52 | 1 |
31397 | 31397 | 2020-04-04 | Newton | Indiana | 18111 | 1 | 0 |
31923 | 31923 | 2020-04-04 | Newton | Mississippi | 28101 | 6 | 0 |
32002 | 32002 | 2020-04-04 | Newton | Missouri | 29145 | 6 | 0 |
32822 | 32822 | 2020-04-04 | Newton | Texas | 48351 | 1 | 0 |
33286 | 33286 | 2020-04-05 | Newton | Arkansas | 5101 | 1 | 0 |
33593 | 33593 | 2020-04-05 | Newton | Georgia | 13217 | 55 | 2 |
33808 | 33808 | 2020-04-05 | Newton | Indiana | 18111 | 4 | 0 |
34350 | 34350 | 2020-04-05 | Newton | Mississippi | 28101 | 7 | 0 |
34430 | 34430 | 2020-04-05 | Newton | Missouri | 29145 | 6 | 0 |
35260 | 35260 | 2020-04-05 | Newton | Texas | 48351 | 1 | 0 |
35730 | 35730 | 2020-04-06 | Newton | Arkansas | 5101 | 1 | 0 |
36043 | 36043 | 2020-04-06 | Newton | Georgia | 13217 | 65 | 2 |
36261 | 36261 | 2020-04-06 | Newton | Indiana | 18111 | 4 | 1 |
36813 | 36813 | 2020-04-06 | Newton | Mississippi | 28101 | 7 | 0 |
36895 | 36895 | 2020-04-06 | Newton | Missouri | 29145 | 6 | 0 |
37736 | 37736 | 2020-04-06 | Newton | Texas | 48351 | 1 | 0 |
38219 | 38219 | 2020-04-07 | Newton | Arkansas | 5101 | 1 | 0 |
38536 | 38536 | 2020-04-07 | Newton | Georgia | 13217 | 67 | 3 |
38759 | 38759 | 2020-04-07 | Newton | Indiana | 18111 | 6 | 1 |
39324 | 39324 | 2020-04-07 | Newton | Mississippi | 28101 | 7 | 0 |
39408 | 39408 | 2020-04-07 | Newton | Missouri | 29145 | 6 | 0 |
40265 | 40265 | 2020-04-07 | Newton | Texas | 48351 | 1 | 0 |
40763 | 40763 | 2020-04-08 | Newton | Arkansas | 5101 | 1 | 0 |
41080 | 41080 | 2020-04-08 | Newton | Georgia | 13217 | 67 | 3 |
41305 | 41305 | 2020-04-08 | Newton | Indiana | 18111 | 6 | 1 |
41878 | 41878 | 2020-04-08 | Newton | Mississippi | 28101 | 7 | 0 |
41962 | 41962 | 2020-04-08 | Newton | Missouri | 29145 | 6 | 0 |
42833 | 42833 | 2020-04-08 | Newton | Texas | 48351 | 1 | 0 |
43335 | 43335 | 2020-04-09 | Newton | Arkansas | 5101 | 1 | 0 |
43654 | 43654 | 2020-04-09 | Newton | Georgia | 13217 | 70 | 3 |
43881 | 43881 | 2020-04-09 | Newton | Indiana | 18111 | 6 | 1 |
44455 | 44455 | 2020-04-09 | Newton | Mississippi | 28101 | 8 | 0 |
44539 | 44539 | 2020-04-09 | Newton | Missouri | 29145 | 7 | 0 |
45425 | 45425 | 2020-04-09 | Newton | Texas | 48351 | 1 | 0 |
45935 | 45935 | 2020-04-10 | Newton | Arkansas | 5101 | 1 | 0 |
46256 | 46256 | 2020-04-10 | Newton | Georgia | 13217 | 77 | 3 |
46485 | 46485 | 2020-04-10 | Newton | Indiana | 18111 | 7 | 1 |
47064 | 47064 | 2020-04-10 | Newton | Mississippi | 28101 | 10 | 0 |
47148 | 47148 | 2020-04-10 | Newton | Missouri | 29145 | 7 | 0 |
48046 | 48046 | 2020-04-10 | Newton | Texas | 48351 | 1 | 0 |
48565 | 48565 | 2020-04-11 | Newton | Arkansas | 5101 | 1 | 0 |
48887 | 48887 | 2020-04-11 | Newton | Georgia | 13217 | 78 | 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);