names

37 rows where place_id = 592685

✎ 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
3608514 1870323 1870323 defendant Rayner John yeoman 592685 592685 Rayner, John, of Hothfeld, yeoman 0
3608515 1870323 1870323 defendant at Mell Andrew husbandman 592685 592685 at Mell, Andrew, of Hothfeld, husbandman 1
3664708 1914915 1914915 defendant Harlakynden John   592685 592685 Harlakynden, John, of Hothfeld, cloth maker 0
3735341 1937290 1937290 plaintiff Harlakynden Thomas   592685 592685 Harlakynden, Thomas, of Hothfeld 0
3742249 1939445 1939445 defendant Ham William smith 592685 592685 Ham, William, of Hothfeld, smith 0
3789532 1954551 1954551 defendant Bryg Richard butcher 592685 592685 Bryg, Richard, of Hothfeld, butcher 0
4471663 2191801 2191801 defendant Bakere Walter   592685 592685 Bakere, Walter, of Hothfeld 0
4577893 2224590 2224590 defendant Bakere William   592685 592685 Bakere William, of Hothfeld 2
4730792 2274832 2274832 defendant Essex William husbandman 592685 592685 Essex, William, of Hothfeld, husbandman 1
4730793 2274832 2274832 defendant Essex Robert laborer 592685 592685 Essex, Robert, of Hothfeld, laborer 2
4902183 2327293 2327293 defendant Chapman Stephen butcher 592685 592685 Chapman, Stephen, of Hothfeld, butcher 0
4902216 2327300 2327300 defendant Topynden Richard laborer 592685 592685 Topynden, Richard, of Hothfeld, laborer 0
4902217 2327300 2327300 defendant Sander Thomas weaver 592685 592685 Sander, Thomas, of Hothfeld, weaver 1
4976041 2349798 2349798 defendant Carpenter William laborer 592685 592685 Carpenter, William, of Hothfeld, laborer 0
4989197 2353703 2353703 defendant Fysshewyk John laborer 592685 592685 Fysshewyk, John, of Hothfeld, laborer 0
5067762 2376858 2376858 defendant Bregge William carpenter 592685 592685 Bregge, William, of Hothfeld, carpenter 0
5118556 2391858 2391858 defendant Bresynden Henry butcher 592685 592685 Bresynden, Henry, of Hothfeld, butcher 0
5153710 2402243 2402243 defendant Mapellesden Henry husbandman 592685 592685 Mapellesden, Henry, of Hothfeld, husbandman 1
5153711 2402243 2402243 defendant Toppeclyff Nicholas smith 592685 592685 Toppeclyff, Nicholas, of Hothfeld, smith 2
5153712 2402243 2402243 defendant Grygge William   592685 592685 Grygge, William, of Hothfeld, shoe maker 3
5237961 2426692 2426692 defendant Lokke Nicholas   592685 592685 Lokke, Nicholas, of Hothfeld, servant 0
5254627 2431567 2431567 defendant Carpenter William husbandman 592685 592685 Carpenter, William, of Hothfeld, husbandman 3
5277654 2438546 2438546 defendant Bregge Richard chapman 592685 592685 Bregge, Richard, of Hothfeld, chapman 0
5296498 2443967 2443967 defendant at Mille Lawrence dyer 592685 592685 at Mille, Lawrence, of Hothfeld, dyer 0
5296499 2443967 2443967 defendant Culverynden Thomas husbandman 592685 592685 Culverynden, Thomas, of Hothfeld, husbandman 1
5339651 2456975 2456975 defendant Mille Thomas husbandman 592685 592685 Mille, Thomas, of Hothfeld, husbandman 0
5386868 2471307 2471307 defendant Avent Thomas husbandman 592685 592685 Avent, Thomas, of Hothfeld, husbandman 0
5396361 2474051 2474051 defendant Hauter Roger laborer 592685 592685 Hauter, Roger, of Hothfeld, laborer 0
5410873 2478204 2478204 defendant Mille John carpenter 592685 592685 Mille, John, of Hothfeld, carpenter 0
5410874 2478204 2478204 defendant Bregge Roger fuller 592685 592685 Bregge, Roger, of Hothfeld, fuller 1
5462822 2493790 2493790 defendant Brewer Thomas shoemaker 592685 592685 Brewer, Thomas, of Hothfeld, shoemaker 0
5474346 2497307 2497307 defendant Brewer Thomas shoemaker 592685 592685 Brewer, Thomas, of Hothfeld, shoemaker 0
5478444 2498579 2498579 defendant Hanter or Hauter Roger laborer 592685 592685 Hanter or Hauter, Roger, of Hothfeld, laborer 0
5478445 2498579 2498579 defendant Loket Alice widow 592685 592685 Loket, Alice, of Hothfeld, widow 1
5478448 2498579 2498579 defendant Broun Thomas laborer 592685 592685 Broun, Thomas, of Hothfeld, laborer 4
5486452 2500840 2500840 defendant Carpynter William husbandman 592685 592685 Carpynter, William, of Hothfeld, husbandman 0
5616304 2548894 2548894 defendant Chapman Adam   592685 592685 Chapman, Adam, of Hothfeld 2

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