names

29 rows where place_id = 596174

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623485 1874877 1874877 defendant Chekford Richard yeoman 596174 596174 Chekford, Richard, of Shirburne, yeoman 6
4420457 2171304 2171304 defendant Hulkyng John   596174 596174 Hulkyng, John, of Shirburne, son of Alexander 0
4460792 2188434 2188434 defendant Boveton William   596174 596174 Boveton, William, of Shirburne 0
4646099 2244931 2244931 defendant Fleccher William   596174 596174 Fleccher, William, of Shirburne 4
4656275 2247856 2247856 defendant Forde Joan widow of John Cokere 596174 596174 Joan his wife, widow of John Cokere, of Shirburne 1
4672734 2257116 2257116 defendant Quynton Thomas husbandman 596174 596174 Quynton, Thomas, of Shirburne, husbandman 0
4672735 2257116 2257116 defendant Darlyngton Thomas husbandman 596174 596174 Darlyngton, Thomas, of Shirburne, husbandman 1
4672736 2257116 2257116 defendant Lane Thomas husbandman 596174 596174 Lane, Thomas, of Shirburne, husbandman 2
4672737 2257116 2257116 defendant Lane Walter husbandman 596174 596174 Lane, Walter, of Shirburne, husbandman 3
4672738 2257116 2257116 defendant atte Na--- Roger husbandman 596174 596174 atte Na---, Roger, of Shirburne, husbandman 4
4672739 2257116 2257116 defendant Jaket Nicholas husbandman 596174 596174 Jaket, Nicholas, of Shirburne, husbandman 5
4751356 2280874 2280874 defendant Dene John brasier 596174 596174 Dene, John, of Shirburne, brasier 0
4751357 2280874 2280874 defendant Cotell Robert brewer 596174 596174 Cotell, Robert, of Shirburne, brewer 1
4751358 2280874 2280874 defendant Milleward John   596174 596174 Milleward, John, of Shirburne, millward 2
4780994 2290061 2290061 plaintiff Carter John   596174 596174 Carter, John, of Shirburne 0
4790282 2293046 2293046 defendant Makemery John weaver 596174 596174 Makemery, John, of Shirburne, weaver 0
4835130 2306987 2306987 defendant Colyngrugge Bartholomew husbandman 596174 596174 Colyngrugge, Bartholomew, of Shirburne, husbandman 0
4995507 2355496 2355496 defendant Knappe Robert merchant 596174 596174 Knappe, Robert, of Shirburne, merchant 0
5023771 2363859 2363859 defendant Vache Richard barber 596174 596174 Vache, Richard, of Shirburne, barber 0
5023773 2363859 2363859 defendant Hawelyn John laborer 596174 596174 Hawelyn, John, of Shirburne, laborer 2
5026422 2364617 2364617 plaintiff Leche Oliver   596174 596174 Leche, Oliver, of Shirburne 0
5054396 2372892 2372892 defendant Hikkes John, senior husbandman 596174 596174 Hikkes, John, senior, of Shirburne, husbandman 0
5086724 2382510 2382510 plaintiff Hillary Robert   596174 596174 Hillary, Robert, of Shirburne 0
5113161 2390246 2390246 defendant Forox or Forcx Elias merchant 596174 596174 Forox or Forcx, Elias, of Shirburne, merchant 0
5222599 2422326 2422326 defendant Wodelond William (legal representative) 596174 596174 Wodelond, William, of Shirburne, clothmaker, executrix of 0
5222600 2422326 2422326 defendant Wodelond Edith widow 596174 596174 Wodelond, Edith, of Shirburne, widow 1
5397752 2474428 2474428 defendant Bryghtrygge Thomas   596174 596174 Bryghtrygge, Thomas, of Shirburne 2
5582616 2529631 2529631 defendant Baskerfeld Philip gent 596174 596174 Baskerfeld, Philip, of Shirburne, gent 0
5613809 2548093 2548093 defendant del Skales John   596174 596174 del Skales, John, of Shirburne 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);