names

30 rows where place_id = 594089

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614518 1872189 1872189 defendant Briggys Richard yeoman 594089 594089 Briggys, Richard, of Romford, Essex, yeoman 0
3614522 1872190 1872190 defendant Bryggys Richard yeoman 594089 594089 Bryggys, Richard, of Romford, Essex, yeoman 0
3661861 1913996 1913996 defendant Hales Marcel   594089 594089 Hales, Marcel, of Romford, Essex 0
3672898 1917537 1917537 defendant Dorbrond John chapman 594089 594089 Dorbrond, John, of Romford, Essex, chapman 4
3748886 1941587 1941587 defendant Cooke John (legal representative) 594089 594089 Cooke, John, of Romford, Essex, esq, executor of 0
3941548 2004186 2004186 defendant Halys Thomas gent 594089 594089 Halys, Thomas, of Romford, Essex, gent 0
3975626 2016035 2016035 defendant Bastyck or Bastwyk John   594089 594089 Bastyck or Bastwyk, John, of Romford, Essex, yeoman, son of John Bastwyk 0
3985352 2019519 2019519 defendant Rede Arthur husbandman 594089 594089 Rede, Arthur, of Romford, Essex, husbandman 1
4319397 2136889 2136889 defendant Francklyn Peter innholder 594089 594089 Francklyn, Peter, of Romford, Essex, innholder 1
4338553 2143236 2143236 defendant Bastwick John carpenter 594089 594089 Bastwick, John, of Romford, Essex, carpenter 0
4515746 2205352 2205352 defendant Gayte William   594089 594089 Gayte, William, of Romford, Essex 0
4694512 2263776 2263776 defendant atte Hethe Walter husbandman 594089 594089 atte Hethe, Walter, of Romford, Essex, husbandman 0
4694514 2263777 2263777 defendant atte Hethe Waltter husbandman 594089 594089 atte Hethe, Waltter, of Romford, Essex, husbandman 0
4699495 2265296 2265296 defendant Wro Thomas chandler 594089 594089 Wro, Thomas, of Romford, Essex, chandler 1
4915821 2331447 2331447 defendant Quylter Ralph husbandman 594089 594089 Quylter, Ralph, of Romford, Essex, husbandman 1
4970325 2348073 2348073 defendant Marchall John husbandman 594089 594089 Marchall, John, of Romford, Essex, husbandman 0
4970328 2348074 2348074 defendant Marchall John husbandman 594089 594089 Marchall, John, of Romford, Essex, husbandman 0
4989148 2353692 2353692 defendant Spycer John chapman 594089 594089 Spycer, John, of Romford, Essex, chapman 1
5011666 2360263 2360263 defendant Marshall John husbandman 594089 594089 Marshall, John, of Romford, Essex, husbandman 1
5011674 2360264 2360264 defendant Marshall John husbandman 594089 594089 Marshall, John, of Romford, Essex, husbandman 1
5156497 2403056 2403056 defendant Carrowe Thomas husbandman 594089 594089 Carrowe, Thomas, of Romford, Essex, husbandman 2
5175401 2408497 2408497 defendant Harpeley Richard   594089 594089 Harpeley, Richard, of Romford, Essex, mason 0
5192397 2413512 2413512 defendant Carrowe Thomas husbandman 594089 594089 Carrowe, Thomas, of Romford, Essex, husbandman 2
5196574 2414749 2414749 defendant Harpeley Richard   594089 594089 Harpeley, Richard, of Romford, Essex, mason 0
5202967 2416630 2416630 defendant Hammes John gent 594089 594089 Hammes, John, of Romford, Essex, gent 0
5207741 2418002 2418002 defendant Carrowe Thomas husbandman 594089 594089 Carrowe, Thomas, of Romford, Essex, husbandman 3
5211121 2418979 2418979 defendant Kent John butcher 594089 594089 Kent, John, of Romford, Essex, butcher 1
5304178 2446257 2446257 defendant Roy_ John glover 594089 594089 Roy_, John, of Romford, Essex, glover 0
5517315 2510255 2510255 defendant Alyson Richard innholder 594089 594089 Alyson, Richard, of Romford, Essex, innholder 0
5517327 2510259 2510259 defendant Alyson Richard innholder 594089 594089 Alyson, Richard, of Romford, Essex, innholder 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);