names

22 rows where place_id = 785837

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4694585 2263802 2263802 defendant Cole Robert yeoman 785837 785837 Cole, Robert, of Needham Market, yeoman 0
4698940 2265147 2265147 defendant Wynde Thomas baker 785837 785837 Wynde, Thomas, of Needham Market, baker 0
4701556 2265880 2265880 defendant Nowell William yeoman 785837 785837 Nowell, William, of Needham Market, yeoman 0
4705260 2267015 2267015 defendant Fyssher Robert   785837 785837 Fyssher, Robert, of Needham Market, corn loder 0
4705261 2267015 2267015 defendant Fyssher Alice daughter of Robert Fyssher 785837 785837 Fyssher, Alice, of Needham Market, spinster, daughter of Robert Fyssher 1
4705662 2267145 2267145 defendant Turnour John yeoman 785837 785837 Turnour, John, of Needham Market, yeoman 0
4735274 2276179 2276179 defendant Elyngham John, sen butcher 785837 785837 Elyngham, John, sen, of Needham Market, butcher 0
4735275 2276179 2276179 defendant Marchale Ralph yeoman 785837 785837 Marchale, Ralph, of Needham Market, yeoman 1
4755358 2282064 2282064 defendant Taston Thomas yeoman 785837 785837 Taston, Thomas, of Needham Market, yeoman 1
4772261 2287294 2287294 plaintiff Sparwe Robert   785837 785837 Sparwe, Robert, of Needham Market 0
4772680 2287427 2287427 defendant Nowell William yeoman 785837 785837 Nowell, William, of Needham Market, yeoman 1
4841358 2308833 2308833 plaintiff Josepp Thomas   785837 785837 Josepp, Thomas, of Needham Market 0
4843215 2309399 2309399 defendant Sparwe John laborer 785837 785837 Sparwe, John, of Needham Market, laborer 4
4938959 2338576 2338576 defendant Josep Thomas pedder 785837 785837 Josep, Thomas, of Needham Market, pedder 0
4997046 2355969 2355969 defendant Bocher John butcher 785837 785837 Bocher, John, of Needham Market, butcher 0
4997047 2355969 2355969 defendant Bocher Robert butcher 785837 785837 Bocher, Robert, of Needham Market, butcher 1
5139336 2397994 2397994 defendant Wynde Robert   785837 785837 Wynde, Robert, of Needham Market 0
5182664 2410685 2410685 plaintiff Cole John butcher 785837 785837 Cole, John, of Needham Market, butcher 0
5470013 2495950 2495950 defendant Cake Edward dyer 785837 785837 Cake, Edward, of Needham Market, dyer 0
5569637 2525689 2525689 plaintiff Harplee Richard   785837 785837 Harplee, Richard, of Needham Market 0
5584542 2530235 2530235 plaintiff Harplee Richard   785837 785837 Harplee, Richard, of Needham Market 0
5584544 2530236 2530236 plaintiff Harplee Richard   785837 785837 Harplee, Richard, of Needham Market 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);