names

32 rows where place_id = 587669

✎ 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
3592092 1865142 1865142 plaintiff Fowell alias Folle William   587669 587669 Fowell alias Folle, William, of Magna Charte 0
3610646 1870997 1870997 defendant Tepynden John tailor 587669 587669 Tepynden, John, of Magna Charte, tailor 2
3618119 1873290 1873290 defendant Crouche John husbandman 587669 587669 Crouche, John, of Magna Charte, husbandman 0
3620294 1873926 1873926 defendant Curlyng Roger husbandman 587669 587669 Curlyng, Roger, of Magna Charte, husbandman 0
3620295 1873926 1873926 defendant Whittok George cordwainer 587669 587669 Whittok, George, of Magna Charte, cordwainer 1
3648163 1909821 1909821 defendant Brette John yeoman or butcher 587669 587669 Brette, John, of Magna Charte, yeoman or butcher 0
3705754 1928081 1928081 defendant Frengeham Thomas yeoman 587669 587669 Frengeham, Thomas, of Magna Charte, yeoman 0
3705755 1928081 1928081 defendant Lowys George gent 587669 587669 Lowys, George, of Magna Charte, gent 1
3772351 1949038 1949038 defendant Redsole John yeoman 587669 587669 Redsole, John, of Magna Charte, yeoman 1
3834143 1968621 1968621 defendant Engeham Richard esq 587669 587669 Engeham, Richard, of Magna Charte, esq 1
3839842 1970393 1970393 defendant Frencham Clement carpenter 587669 587669 Frencham, Clement, of Magna Charte, carpenter 0
3839843 1970393 1970393 defendant Afryghte Stephen husbandman 587669 587669 Afryghte, Stephen, of Magna Charte, husbandman 1
4009273 2028080 2028080 defendant Felthorpe John gent 587669 587669 Felthorpe, John, of Magna Charte, gent 2
4058289 2045350 2045350 defendant Baxster Nathaniel clerk 587669 587669 Baxster, Nathaniel, of Magna Charte, clerk 0
4062944 2047047 2047047 defendant Baxter Nathaniel clerk 587669 587669 Baxter, Nathaniel, of Magna Charte, clerk 0
4223841 2103824 2103824 defendant Goldwell John gent 587669 587669 Goldwell, John, of Magna Charte, gent 0
4223842 2103824 2103824 defendant Lugson or Lugston Andrew yeoman 587669 587669 Lugson or Lugston, Andrew, of Magna Charte, yeoman 1
4225466 2104372 2104372 defendant A Pryce alias Morrys John laborer 587669 587669 A Pryce alias Morrys, John, of Magna Charte, laborer 0
4265851 2118220 2118220 defendant A Pryce alias Morrys John laborer 587669 587669 A Pryce alias Morrys, John, of Magna Charte, laborer 0
5107984 2388776 2388776 defendant Murcok Thomas husbandman 587669 587669 Murcok, Thomas, of Magna Charte, husbandman 2
5220555 2421709 2421709 defendant Berwe Thomas yeoman 587669 587669 Berwe, Thomas, of Magna Charte, yeoman 0
5220560 2421710 2421710 defendant Berwe Thomas yeoman 587669 587669 Berwe, Thomas, of Magna Charte, yeoman 3
5252311 2430832 2430832 defendant Laurence William baker 587669 587669 Laurence, William, of Magna Charte, baker 1
5253968 2431359 2431359 defendant Grygge alias Gregory Henry laborer 587669 587669 Grygge alias Gregory, Henry, of Magna Charte, or of Rokynge, laborer 0
5254918 2431651 2431651 defendant Sprotte Andrew yeoman 587669 587669 Sprotte, Andrew, of Magna Charte, yeoman 0
5284974 2440628 2440628 defendant Hamme James smith 587669 587669 Hamme, James, of Magna Charte, smith 0
5284975 2440628 2440628 defendant Sprotte Richard yeoman 587669 587669 Sprotte, Richard, of Magna Charte, yeoman 1
5284976 2440628 2440628 defendant Bever Richard weaver 587669 587669 Bever, Richard, of Magna Charte, weaver 2
5293985 2443213 2443213 defendant Assheherst John laborer 587669 587669 Assheherst, John, of Magna Charte, laborer 0
5538910 2516656 2516656 defendant Mille Robert weaver 587669 587669 Mille, Robert, of Magna Charte, weaver 0
5552418 2520760 2520760 defendant Johnson Richard laborer 587669 587669 Johnson, Richard, of Magna Charte, laborer 0
5606318 2536871 2536871 defendant Lynche Thomas clothmaker 587669 587669 Lynche, Thomas, of Magna Charte, clothmaker 0

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