r_address
116,046 rows
Suggested facets: state_alpha, state_numeric
| case_number | address | city | state_alpha | state_numeric |
|---|---|---|---|---|
| 01-AC-000077 | 1586 HYDE PARK AVENUE | BOSTON | MA | 20 |
| 01-AC-000078 | 447 WEST LOWELL AVENUE | HAVERHILL | MA | 20 |
| 01-AC-000079 | 30 BOLTWOOD AVE | AMHERST | MA | 20 |
| 01-AC-000080 | 25 BUICK ST | BOSTON | MA | 20 |
| 01-AC-000081 | ZERO(0) MARTSON ST | LAWRENCE | MA | 20 |
| 01-AC-000082 | ZERO MARSTON STREET | LAWRENCE | MA | 20 |
| 01-AC-000083 | 195 MARKET STREET | LYNN | MA | 20 |
| 01-AC-000084 | T.F. GREEN STATE AIRPORT HR.# | WARWICK | RI | 38 |
| 01-AC-000085 | 14 CHURCH GREEN ST | TAUNTON | MA | 20 |
| 01-AC-000086 | YANKEE ATOMIC PLANT | ROWE | MA | 20 |
| 01-AC-000087 | 354 PINE STREET | PAWTUCKET | RI | 38 |
| 01-AC-000088 | ONE HOYT STREET | BOSTON | MA | 20 |
| 01-AC-000089 | 1030 UNIVERSITY AVENUE | NORWOOD | MA | 20 |
| 01-AC-000090 | 1012 BROADWAY | CHELSEA | MA | 20 |
| 01-AC-000091 | 295 PARKER STREET | INDIAN ORCHARD | MA | 20 |
| 01-AC-000092 | OLD FERRY ROAD | BRATTLEBORO | VT | 44 |
| 01-RC-015889 | 100 MAIN ST | HARTFORD | MA | 20 |
| 01-RC-017055 | 180 NEW BOSTON STREET | WOBURN | MA | 20 |
| 01-RC-017183 | 874 BRIGHTON AVENUE | PORTLAND | ME | 18 |
| 01-RC-017262 | WHITES BRIDGE ROAD | NO. WINDHAM | ME | 18 |
| 01-RC-017441 | 319 LYNNWAY | LYNN | MA | 20 |
| 01-RC-017475 | SPRINGFIELD | VT | 44 | |
| 01-RC-017569 | 190 N. MAIN STREET | OLD TOWN | ME | 18 |
| 01-RC-017622 | PITTSFIELD | MA | 20 | |
| 01-RC-017696 | OLD STREET ROAD | PETERBOROUGH | NH | 28 |
| 01-RC-017700 | MAIN STREET | WILLIAMSTOWN | MA | 20 |
| 01-RC-017711 | 825 UNIVERSITY AVENUE | NORWOOD | MA | 20 |
| 01-RC-017718 | MYRTLE STREET | ADAMS | MA | 20 |
| 01-RC-017724 | 2382 BOSTON ROAD | NORTH WILBRAHAM | MA | 20 |
| 01-RC-017736 | 50 FOSTER STREET | WORCESTER | MA | 20 |
| 01-RC-017751 | 50 FOSTER STREET | WORCESTER | MA | 20 |
| 01-RC-017757 | MA | 20 | ||
| 01-RC-017764 | 121 LAKEVIEW | LINCOLN | ME | 18 |
| 01-RC-017782 | 50 FOSTER ST | WORCESTER | MA | 20 |
| 01-RC-017785 | MAIN STREET | NO. OXFORD | MA | 20 |
| 01-RC-017790 | WORCESTER CENTRUM | WORCESTER | MA | 20 |
| 01-RC-017813 | COOK'S CORNER PLAZA | BRUNSWICK | ME | 18 |
| 01-RC-017823 | 287 ALLENS AVENUE | PROVIDENCE | RI | 38 |
| 01-RC-017829 | 33 SCHOOL STREET | VEAZIE | ME | 18 |
| 01-RC-017830 | 50 FRANKLIN ST | CALAIS | ME | 18 |
| 01-RC-017842 | 84 ROWE STREET | NEWTON | MA | 20 |
| 01-RC-017843 | CAMBRIDGE | MA | 20 | |
| 01-RC-017863 | 1 GOLDTHWAITE ROAD | AUBURN | ME | 18 |
| 01-RC-017876 | 1600 OSGOOD STREET | NORTH ANDOVER | MA | 20 |
| 01-RC-017896 | 25 FLAGSTONE DR. | HUDSON | VT | 44 |
| 01-RC-017897 | STATION STREET | NEW LIMERICK | ME | 18 |
| 01-RC-017904 | MASSACHUSETTS HALL | CAMBRIDGE | MA | 20 |
| 01-RC-017923 | 9 MARBLE ST. | WHITMAN | MA | 20 |
| 01-RC-017930 | 66B INDUSTRY AVE. | SPRINGFIELD | MA | 20 |
| 01-RC-017932 | LOGAN AIRPORT | EAST BOSTON | MA | 20 |
| 01-RC-017934 | 233 HARVARD STREET | BROOKLINE | MA | 20 |
| 01-RC-017939 | 1770 SOLDIERS FIELD ROAD | BOSTON | MA | 20 |
| 01-RC-017940 | P.O. BOX 1000 | EXETER | NH | 28 |
| 01-RC-017947 | 33 SCHOOL STREET | VEAZIE | ME | 18 |
| 01-RC-017949 | HERMAN MELVILLE BOULEVARD | NEW BEDFORD | MA | 20 |
| 01-RC-017952 | 133 MAIN STREET | MEDFORD | MA | 20 |
| 01-RC-017953 | 10 SPRING STREET | NEWPORT | ME | 18 |
| 01-RC-017955 | 791 1/2 SABATTUS STREET | LEWISTON | ME | 18 |
| 01-RC-017962 | 866 MAIN STREET | MALDEN | MA | 20 |
| 01-RC-017964 | 400 REVERE BEACH BOULEVARD | REVERE | MA | 20 |
| 01-RC-017968 | FOUR MUNROE STREET | CAMBRIDGE | MA | 20 |
| 01-RC-017969 | 276 AMORY STREET | JAMAICA PLAIN | MA | 20 |
| 01-RC-017972 | 80 WEBSTER STREET | WORCESTER | MA | 20 |
| 01-RC-017973 | 80 WEBSTER STREET | WORCESTER | MA | 20 |
| 01-RC-017974 | 69 NORMAN STREET | EVERETT | MA | 20 |
| 01-RC-017977 | 67-4TH AVENUE | NEEDHAM HEIGHTS | MA | 20 |
| 01-RC-017978 | 210 BEACHAM STREET | EVERETT | MA | 20 |
| 01-RC-017982 | 15 ARLINGTON ST. | BOSTON | MA | 20 |
| 01-RC-017983 | 475 CANAL ST. | HOLYOKE | MA | 20 |
| 01-RC-017984 | P.O. BOX 238 LINDEN ST. | HOLYOKE | MA | 20 |
| 01-RC-017985 | 64 PARK STREET | DEXTER | ME | 18 |
| 01-RC-017986 | 200 SOMERSET ST. | MILLINOCKET | ME | 18 |
| 01-RC-017987 | 606 COMMONWEALTH AVE. | BOSTON | MA | 20 |
| 01-RC-017988 | 1100 FORREST AVENUE | PORTLAND | ME | 18 |
| 01-RC-017989 | 53 MASON STREET | SALEM | MA | 20 |
| 01-RC-017990 | MIDDLESEX INDUSTRIAL PK. | STONEHAM | MA | 20 |
| 01-RC-017991 | 41 BERKLEY STREET | BOSTON | MA | 20 |
| 01-RC-017992 | 80 WEBSTER STREET | WORCESTER | MA | 20 |
| 01-RC-017993 | 1352 BEACON STREET | BROOKLINE | MA | 20 |
| 01-RC-017994 | 82 HIGHLAND AVENUE | SALEM | MA | 20 |
| 01-RC-017995 | OTIS STREET | WESTBORO | MA | 20 |
| 01-RC-017996 | 103 SOUTH MAIN STREET | BARRE | VT | 44 |
| 01-RC-017997 | 100 PULASKI STREET | WEST WARWICK | RI | 38 |
| 01-RC-017998 | ALFRED ROAD INDUSTRIAL PARK | BIDDEFORD | ME | 18 |
| 01-RC-017999 | BOX 600 SOUTH WEST CUTOFF | NORTHBORO | MA | 20 |
| 01-RC-018000 | 20 BROAD ST. | WESTFIELD | MA | 20 |
| 01-RC-018001 | P.O. BOX 151 | MIDDLEBURY | VT | 44 |
| 01-RC-018002 | 716 COLUMBUS AVE. | ROXBURY | MA | 20 |
| 01-RC-018003 | INDUSTRIAL PARK | PLYMOUTH | MA | 20 |
| 01-RC-018004 | 35 PIERCE ST. | GREENFIELD | MA | 20 |
| 01-RC-018005 | OLD ROAD TO NINE ACRE CORNER | CONCORD | MA | 20 |
| 01-RC-018006 | 10 WELLINGTON AVENUE | FRAMINGHAM | MA | 20 |
| 01-RC-018007 | 206 GLOBE MILLS AVE. | FALL RIVER | MA | 20 |
| 01-RC-018008 | 108 SOUTH ST. | HOPKINTON | MA | 20 |
| 01-RC-018009 | 99 ARNOLD STREET | SPRINGFIELD | MA | 20 |
| 01-RC-018010 | 237 OXFORD STREET | PORTLAND | ME | 18 |
| 01-RC-018011 | 64 PARK STREET | DEXTER | ME | 18 |
| 01-RC-018012 | 216 TREMONT STREET | BOSTON | MA | 20 |
| 01-RC-018013 | SERVICE CENTER RD., P.O. 840 | NORTHAMPTON | MA | 20 |
| 01-RC-018014 | 17-35 MYRTLE STREET | LYNN | MA | 20 |
Table schema
CREATE TABLE r_address(case_number VARCHAR, address VARCHAR, city VARCHAR, state_alpha VARCHAR, state_numeric VARCHAR);