names

27 rows where place_id = 588329

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594125 1865805 1865805 defendant Aleyn Edmund husbandman 588329 588329 Aleyn, Edmund, of Hasyngham, husbandman 0
3601258 1868056 1868056 defendant Croftys Richard clerk 588329 588329 Croftys, Richard, of Hasyngham, clerk 0
3779199 1951215 1951215 defendant Long John husbandman 588329 588329 Long, John, of Hasyngham, husbandman 0
3896139 1988912 1988912 defendant Hande William husbandman 588329 588329 Hande, William, of Hasyngham, husbandman 3
4164436 2083080 2083080 defendant Payne Edmund clerk 588329 588329 Payne, Edmund, of Hasyngham, clerk 0
4654375 2247242 2247242 plaintiff Aleyn John   588329 588329 Aleyn, John, of Hasyngham 1
4789845 2292892 2292892 defendant Camplion Richard husbandman 588329 588329 Camplion, Richard, of Hasyngham, husbandman 0
4801680 2296707 2296707 defendant Hulbuk Nicholas yeoman 588329 588329 Hulbuk, Nicholas, of Hasyngham, yeoman 4
4887224 2322843 2322843 defendant Holbek Nicholas husbandman 588329 588329 Holbek, Nicholas, of Hasyngham, husbandman 4
4952794 2342792 2342792 defendant Holbroke John yeoman 588329 588329 Holbroke, John, of Hasyngham, yeoman 2
5136146 2397084 2397084 defendant (illegible) (illegible) yeoman 588329 588329 --, --, of Hasyngham, yeoman 0
5156465 2403046 2403046 defendant Camplyon William yeoman 588329 588329 Camplyon, William, of Hasyngham, yeoman 0
5156468 2403047 2403047 defendant Camplyon William yeoman 588329 588329 Camplyon, William, of Hasyngham, yeoman 0
5161001 2404321 2404321 defendant Camplyon William husbandman 588329 588329 Camplyon, William, of Hasyngham, husbandman 0
5175576 2408541 2408541 defendant Camplyon William husbandman 588329 588329 Camplyon, William, of Hasyngham, husbandman 0
5222984 2422441 2422441 defendant Camplion William husbandman 588329 588329 Camplion, William, of Hasyngham, husbandman 1
5251733 2430648 2430648 defendant Warner Thomas husbandman 588329 588329 Warner, Thomas, of Hasyngham, husbandman 1
5268430 2435891 2435891 defendant Camplyon William husbandman 588329 588329 Camplyon, William, of Hasyngham, husbandman 2
5268435 2435892 2435892 defendant Camplyon William husbandman 588329 588329 Camplyon, William, of Hasyngham, husbandman 2
5297031 2444127 2444127 defendant Grene Thomas clerk 588329 588329 Grene, Thomas, of Hasyngham, clerk 2
5341433 2457514 2457514 defendant Camplyon William yeoman 588329 588329 Camplyon, William, of Hasyngham, yeoman 1
5366986 2465324 2465324 plaintiff Campyon William (legal representative) 588329 588329 Campyon, William, of Hasyngham, executors of 0
5395284 2473726 2473726 defendant Aleyn Edmund yeoman & bachelor 588329 588329 Aleyn, Edmund, of Hasyngham, yeoman & bachelor 0
5397771 2474431 2474431 defendant Aleyn Edmund yeoman 588329 588329 Aleyn, Edmund, of Hasyngham, yeoman 0
5397776 2474432 2474432 defendant Aleyn Edmund yeoman 588329 588329 Aleyn, Edmund, of Hasyngham, yeoman 1
5515490 2509686 2509686 defendant Sprout John yeoman 588329 588329 Sprout, John, of Hasyngham, yeoman 1
5534780 2515417 2515417 defendant Baret Thomas husbandman 588329 588329 Baret, Thomas, of Hasyngham, husbandman 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);