names

33 rows where place_id = 596324

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624205 1875103 1875103 defendant Brygge John husbandman 596324 596324 Brygge, John, of Polstede, husbandman 2
4287035 2125415 2125415 defendant Smythe John yeoman 596324 596324 Smythe, John, of Polstede, yeoman 0
4348481 2146720 2146720 defendant Kempe Thomas yeoman 596324 596324 Kempe, Thomas, of Polstede, yeoman 0
4490140 2197636 2197636 defendant Colman John   596324 596324 Colman, John, of Polstede 0
4525912 2208403 2208403 defendant Ducheman John   596324 596324 Ducheman, John, of Polstede 3
4526082 2208453 2208453 defendant Ducheman John   596324 596324 Ducheman, John, of Polstede 3
4544501 2214196 2214196 defendant Ducheman John   596324 596324 Ducheman, John, of Polstede 0
4549134 2215665 2215665 defendant Calle John   596324 596324 Calle, John, of Polstede 0
4549138 2215667 2215667 defendant Ducheman John   596324 596324 Ducheman, John, of Polstede 0
4596015 2230002 2230002 defendant Mey John   596324 596324 Mey, John, of Polstede 0
4596016 2230002 2230002 defendant Vyncent William   596324 596324 Vyncent, William, of Polstede 1
4601552 2231710 2231710 defendant Calle John   596324 596324 Calle, John, of Polstede 0
4607513 2233462 2233462 defendant Capel John   596324 596324 Capel, John, of Polstede 0
4620483 2237387 2237387 defendant Balle John   596324 596324 Balle, John, of Polstede 0
4636925 2242360 2242360 defendant Capell John   596324 596324 Capell, John, of Polstede 0
4674015 2257487 2257487 defendant Brad John   596324 596324 Brad, John, of Polstede, bailiff 1
4674016 2257487 2257487 defendant Warewell William pedder 596324 596324 Warewell, William, of Polstede, pedder 2
4737894 2276956 2276956 defendant Crenche Robert yeoman 596324 596324 Crenche, Robert, of Polstede, yeoman 2
4856013 2313253 2313253 defendant Holbrok Simon yeoman 596324 596324 Holbrok, Simon, of Polstede, yeoman 0
4926107 2334592 2334592 defendant Neel John yeoman 596324 596324 Neel, John, of Polstede, yeoman 2
5015253 2361343 2361343 defendant Carles Robert   596324 596324 Carles, Robert, of Polstede, servant 4
5018664 2362348 2362348 defendant Holbrook John husbandman 596324 596324 Holbrook, John, of Polstede, husbandman 0
5076946 2379600 2379600 defendant Sekelyng John miller 596324 596324 Sekelyng, John, of Polstede, miller 0
5093938 2384626 2384626 defendant Sekelyng John miller 596324 596324 Sekelyng, John, of Polstede, miller 1
5093939 2384626 2384626 defendant Nowell Robert laborer 596324 596324 Nowell, Robert, of Polstede, laborer 2
5126868 2394336 2394336 defendant T--tot John   596324 596324 T--tot, John, of Polstede 0
5140628 2398368 2398368 defendant Ar-- John husbandman 596324 596324 Ar--, John, of Polstede, husbandman 1
5163883 2405172 2405172 defendant Brette John laborer 596324 596324 Brette, John, of Polstede, laborer 0
5176051 2408679 2408679 defendant Arnold John husbandman 596324 596324 Arnold, John, of Polstede, husbandman 1
5197889 2415119 2415119 defendant Arnold John husbandman 596324 596324 Arnold, John, of Polstede, husbandman 1
5260862 2433520 2433520 defendant Gamelyn Robert carpenter 596324 596324 Gamelyn, Robert, of Polstede, carpenter 0
5617993 2549442 2549442 defendant Smyth Peter   596324 596324 Smyth, Peter, of Polstede 2
5632987 2554322 2554322 defendant Hille William   596324 596324 Hille, William, of Polstede, millwright 1

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);