c_address
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | case_number | address | city | state_alpha | state_numeric |
---|---|---|---|---|---|---|
1 | 1 | 01-CA-007643-001 | 100 MAIN ST | BOSTON | MA | 20 |
2 | 2 | 01-CA-007837-001 | 100 MAIN ST | BOSTON | MA | 20 |
3 | 3 | 01-CA-007903-001 | 100 MAIN ST | BOSTON | MA | 20 |
4 | 4 | 01-CA-008742-001 | 8 PORTLAND STREET | WORCESTER | MA | 20 |
5 | 5 | 01-CA-010237-001 | 100 PRESTIGE PARK | BOSTON | MA | 20 |
6 | 6 | 01-CA-010348-001 | 550 POND ST | WOONSOCKET | RI | 38 |
7 | 7 | 01-CA-010379-001 | 100 PRESTIGE PARK | BOSTON | MA | 20 |
8 | 8 | 01-CA-010381-001 | 92 JEFFERSON BLVD | WARWICK | RI | 38 |
9 | 9 | 01-CA-010522-001 | 92 JEFFERSON BLVD | WARWICK | RI | 38 |
10 | 10 | 01-CA-010585-001 | 360 SECOND AVENUE | WALTHAM | MA | 20 |
11 | 11 | 01-CA-011061-001 | 147 BAY STATE ROAD | BOSTON | MA | 20 |
12 | 12 | 01-CA-011491-001 | 770 DERBY AVE SEYMOUR CT | BOSTON | MA | 20 |
13 | 13 | 01-CA-011524-001 | 700 KEMPTON STREET | NEW BEDFORD | MA | 20 |
14 | 14 | 01-CA-011628-001 | 162 MYSTIC AVE. | MEDFORD | MA | 20 |
15 | 15 | 01-CA-011684-001 | 100 NEWARK STREET | HAVERHILL | MA | 20 |
16 | 16 | 01-CA-011733-001 | MAIN ST | FALL RIVER | MA | 20 |
17 | 17 | 01-CA-011760-001 | 100 MAIN ST | MANCHESTER | NH | 28 |
18 | 18 | 01-CA-012015-001 | UNITED TECH BLDG HARTFORD CT | BOSTON | MA | 20 |
19 | 19 | 01-CA-012030-001 | 100 NEWARK STREET | HAVERHILL | MA | 20 |
20 | 20 | 01-CA-012102-001 | UNITED TECH BLDG HARTFORD CT | BOSTON | MA | 20 |
21 | 21 | 01-CA-012137-001 | UNITED TECHNOLOGIES BLDG. | HARTFORD | CT | 6 |
22 | 22 | 01-CA-012264-001 | 54 WINTER ST | MALDEN | MA | 20 |
23 | 23 | 01-CA-012370-001 | 54 WINTER ST | MALDEN | MA | 20 |
24 | 24 | 01-CA-012507-001 | 632 BEACON STREET | BOSTON | MA | 20 |
25 | 25 | 01-CA-012508-001 | 45 MAIN ST | BOSTON | MA | 20 |
26 | 26 | 01-CA-012643-001 | 85 GRANBY ST | BOSTON | MA | 20 |
27 | 27 | 01-CA-012715-001 | RIVER RD | BUCKSPORT | ME | 18 |
28 | 28 | 01-CA-012812-001 | 85 GRANBY ST | BOSTON | MA | 20 |
29 | 29 | 01-CA-012838-001 | FRUIT ST | BOSTON | MA | 20 |
30 | 30 | 01-CA-012975-001 | MAIN ST | MADISON | ME | 18 |
31 | 31 | 01-CA-012978-001 | MADISON | ME | 18 | |
32 | 32 | 01-CA-013014-001 | 262POPLAR ST | WOONSOCKET | RI | 38 |
33 | 33 | 01-CA-013016-001 | 770 DERBY AVE SEYMOUR CT | BOSTON | MA | 20 |
34 | 34 | 01-CA-013017-001 | 770 DERBY AVE SEYMOUR CT | BOSTON | MA | 20 |
35 | 35 | 01-CA-013018-001 | 770 DERBY AVE SEYMOUR CT | BOSTON | MA | 20 |
36 | 36 | 01-CA-013019-001 | FRUIT STREET | BOSTON | MA | 20 |
37 | 37 | 01-CA-013057-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
38 | 38 | 01-CA-013167-001 | WESTMINISTER | VT | 44 | |
39 | 39 | 01-CA-013208-001 | 1185 AVENUE OF THE AMERICAS | NEW YORK | NY | 31 |
40 | 40 | 01-CA-013230-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
41 | 41 | 01-CA-013282-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
42 | 42 | 01-CA-013425-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
43 | 43 | 01-CA-013458-001 | 1540 BEACON ST | BOSTON | MA | 20 |
44 | 44 | 01-CA-013486-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
45 | 45 | 01-CA-013497-001 | 85 GRANBY ST | BOSTON | MA | 20 |
46 | 46 | 01-CA-013578-001 | 1540 BEACON ST | BROOKLINE | MA | 20 |
47 | 47 | 01-CA-013586-001 | 375 WASHINGTON STREET | HAVERHILL | MA | 20 |
48 | 48 | 01-CA-013587-001 | 375 WASHINGTON STREET | HAVERHILL | MA | 20 |
49 | 49 | 01-CA-013753-001 | 100 FRUIT STREET | BOSTON | MA | 20 |
50 | 50 | 01-CA-013882-001 | 98 BUSINESS STREET | BOSTON | MA | 20 |
51 | 51 | 01-CA-013913-001 | 85 GRANBY ST | BOSTON | MA | 20 |
52 | 52 | 01-CA-014050-001 | 11 WELLINGTON ROAD | LINCOLN | RI | 38 |
53 | 53 | 01-CA-014071-001 | 375 WASHINGTON ST | HAVERHILL | MA | 20 |
54 | 54 | 01-CA-014085-001 | 11 WELLINGTON CIRCLE | LINCOLN | RI | 38 |
55 | 55 | 01-CA-014086-001 | 11 WELLINGTON CIRCLE | LINCOLN | RI | 38 |
56 | 56 | 01-CA-014204-001 | MAPLE TREE INDUSTRIAL ENTER | PALMER | MA | 20 |
57 | 57 | 01-CA-014224-001 | NEW RD, MADISON, CT | BOSTON | MA | 20 |
58 | 58 | 01-CA-014273-001 | 11 WELLINGTON ROAD | LINCOLN | RI | 38 |
59 | 59 | 01-CA-014274-001 | WELLINGTON CIRCLE | LINCOLN | RI | 38 |
60 | 60 | 01-CA-014347-001 | 98 BUSINESS ST | BOSTON | MA | 20 |
61 | 61 | 01-CA-014383-001 | 98 BUSINESS ST | HYDE PARK | MA | 20 |
62 | 62 | 01-CA-014433-001 | BANGOR, MAINE | BOSTON | MA | 20 |
63 | 63 | 01-CA-014443-001 | 98 BUSINESS ST | HYDE PARK | MA | 20 |
64 | 64 | 01-CA-014475-001 | NEW RD MADISON CT | BOSTON | MA | 20 |
65 | 65 | 01-CA-014495-001 | 110 CHASE STREET | FALL RIVER | MA | 20 |
66 | 66 | 01-CA-014495-002 | 110 CHASE ST. | FALL RIVER | MA | 20 |
67 | 67 | 01-CA-014526-001 | 110 CHASE STREET | FALL RIVER | MA | 20 |
68 | 68 | 01-CA-014600-001 | 11 WELLINGTON CIRCLE | LINCOLN | RI | 38 |
69 | 69 | 01-CA-014619-001 | 375 WASHINGTON STREET | HAVERHILL | MA | 20 |
70 | 70 | 01-CA-014624-001 | 14 AUDUBON ROAD | WAKEFIELD | MA | 20 |
71 | 71 | 01-CA-014700-001 | NEW RD, MADISON, CT | BOSTON | MA | 20 |
72 | 72 | 01-CA-014728-001 | 98 BUSINESS ST | HYDE PARK | MA | 20 |
73 | 73 | 01-CA-014748-001 | BOSTON | MA | 20 | |
74 | 74 | 01-CA-014788-001 | NEW RD, MADISON, CT | BOSTON | MA | 20 |
75 | 75 | 01-CA-014925-001 | 98 BUSINESS ST | BOSTON | MA | 20 |
76 | 76 | 01-CA-014998-001 | 262 POPLAR ST | WOONSOCKET | RI | 38 |
77 | 77 | 01-CA-015206-001 | 11 WELLINGTON RD | LINCOLN | RI | 38 |
78 | 78 | 01-CA-015416-001 | 1185 AVENUE OF THE AMERICA | BOSTOON | MA | 20 |
79 | 79 | 01-CA-015489-001 | 11 WELLINGTONN AVENUE | LINCOLN | RI | 38 |
80 | 80 | 01-CA-015846-001 | WORTHINGTON ST | SPRINGFIELD | MA | 20 |
81 | 81 | 01-CA-015902-001 | 88 HICKS AVE | MEDFORD | MA | 20 |
82 | 82 | 01-CA-015904-001 | 100 CAMBRIDGE ST | BOSTON | MA | 20 |
83 | 83 | 01-CA-015922-001 | WASHINGTON STREET | BOSTON | MA | 20 |
84 | 84 | 01-CA-016026-001 | 88 HICKS AVE | MEDFORD | MA | 20 |
85 | 85 | 01-CA-016082-001 | P.O.BOX 153 | BAR HARBOR | ME | 18 |
86 | 86 | 01-CA-016142-001 | 288 MAIN ST | MONSON | MA | 20 |
87 | 87 | 01-CA-016152-001 | UNITED TECHNOLOGIES BLDG | HARTFORD | CT | 6 |
88 | 88 | 01-CA-016163-001 | 11 WELLINGTON CIR. | LINCOLN | RI | 38 |
89 | 89 | 01-CA-016183-001 | 277 MAIN ST | MONSON | MA | 20 |
90 | 90 | 01-CA-016198-001 | DUNHAM RD | BEVERLY | MA | 20 |
91 | 91 | 01-CA-016314-001 | 1185 AVE. OF THE AMERICAS | NEW YORK N.Y. | MA | 20 |
92 | 92 | 01-CA-016322-001 | 88 HICKS AVE | MEDFORD | MA | 20 |
93 | 93 | 01-CA-016322-002 | 88 HICKS AVE. | MEDFORD | MA | 20 |
94 | 94 | 01-CA-016532-001 | OLD WEBSTER ST | OXFORD | MA | 20 |
95 | 95 | 01-CA-016536-001 | 288 MAIN ST | MONSON | MA | 20 |
96 | 96 | 01-CA-016548-001 | 987 SIMMONS ROAD | WILLIAMSTOWN | MA | 20 |
97 | 97 | 01-CA-016597-001 | OLD WEBSTER ST | OXFORD | MA | 20 |
98 | 98 | 01-CA-016694-001 | 11 WELLINGTON ROAD | LINCOLN | RI | 38 |
99 | 99 | 01-CA-016795-001 | OLD WEBSTER ST | OXFORD | MA | 20 |
100 | 100 | 01-CA-016806-001 | 288 MAIN ST | MONSON | MA | 20 |
CREATE TABLE "c_address" ( [case_number] TEXT REFERENCES [c_master]([case_number]), [address] TEXT, [city] TEXT, [state_alpha] TEXT, [state_numeric] INTEGER );