names

31 rows where place_id = 757115

✎ 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
4443404 2182898 2182898 defendant Calwode John   757115 757115 Calwode, John, of Iteryngham 1
4650810 2246256 2246256 defendant Dykkes William   757115 757115 Dykkes, William, of Iteryngham, parson 0
4670306 2256419 2256419 defendant Elgold Alan clerk 757115 757115 Elgold, Alan, of Iteryngham, clerk 0
4700936 2265696 2265696 defendant Smyth Richard yeoman 757115 757115 Smyth, Richard, of Iteryngham, yeoman 0
4702555 2266211 2266211 plaintiff Mortoft John   757115 757115 Mortoft, John, of Iteryngham 1
4753301 2281412 2281412 defendant Broune William   757115 757115 Broune, William, of Iteryngham, parson 3
4838074 2307829 2307829 defendant Basetheh Roger yeoman 757115 757115 Basetheh, Roger, of Iteryngham, yeoman 1
4865254 2316106 2316106 defendant Brethenham Roger yeoman 757115 757115 Brethenham, Roger, of Iteryngham, yeoman 1
4931521 2336240 2336240 defendant Brechenham Roger husbandman 757115 757115 Brechenham, Roger, of Iteryngham, husbandman 4
4944043 2340107 2340107 defendant Halyday Richard clerk 757115 757115 Halyday, Richard, of Iteryngham, clerk 0
4945031 2340430 2340430 defendant Brethenham Roger yeoman 757115 757115 Brethenham, Roger, of Iteryngham, yeoman 1
4951421 2342406 2342406 defendant Flaxman William yeoman 757115 757115 Flaxman, William, of Iteryngham, yeoman 0
4951422 2342406 2342406 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 1
4977311 2350173 2350173 defendant Brethyngham Roger husbandman 757115 757115 Brethyngham, Roger, of Iteryngham, husbandman 0
4977903 2350351 2350351 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 0
4994136 2355120 2355120 defendant Morcost John yeoman 757115 757115 Morcost, John, of Iteryngham, yeoman 0
5000037 2356892 2356892 defendant Upton John   757115 757115 Upton, John, of Iteryngham, shepherd 2
5004501 2358216 2358216 defendant Flaman William yeoman 757115 757115 Flaman, William, of Iteryngham, yeoman 0
5004502 2358216 2358216 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 1
5037640 2367883 2367883 defendant Crowede John husbandman 757115 757115 Crowede, John, of Iteryngham, husbandman 0
5069264 2377295 2377295 defendant Brethenham Roger yeoman 757115 757115 Brethenham, Roger, of Iteryngham, yeoman 5
5076398 2379441 2379441 defendant Mortoft John gent 757115 757115 Mortoft, John, of Iteryngham, gent 0
5078256 2379984 2379984 defendant Mortoft John gent 757115 757115 Mortoft, John, of Iteryngham, gent 0
5078257 2379984 2379984 defendant Mortoft John, junior gent 757115 757115 Mortoft, John, junior, of Iteryngham, gent 1
5078258 2379984 2379984 defendant Mortoft Robert yeoman 757115 757115 Mortoft, Robert, of Iteryngham, yeoman 2
5091085 2383788 2383788 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 0
5102850 2387251 2387251 defendant Larwode William husbandman 757115 757115 Larwode, William, of Iteryngham, husbandman 2
5124220 2393540 2393540 defendant Pers John husbandman 757115 757115 Pers, John, of Iteryngham, husbandman 3
5124222 2393540 2393540 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 5
5255656 2431886 2431886 defendant Ketyll John chandler 757115 757115 Ketyll, John, of Iteryngham, chandler 1
5260915 2433537 2433537 defendant Passewater Robert husbandman 757115 757115 Passewater, Robert, of Iteryngham, husbandman 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);