names

29 rows where place_id = 595898

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622326 1874519 1874519 defendant Dabbe William husbandman 595898 595898 Dabbe, William, of Poulet, husbandman 1
3663835 1914624 1914624 defendant Stevyn John yeoman 595898 595898 Stevyn, John, of Poulet, yeoman 0
4616705 2236227 2236227 defendant Grove William   595898 595898 Grove, William, of Poulet 0
4616706 2236227 2236227 defendant Grove John   595898 595898 Grove, John, of Poulet 1
4679873 2259312 2259312 defendant Pontesyde Walter husbandman 595898 595898 Pontesyde, Walter, of Poulet, husbandman 0
4697560 2264724 2264724 defendant Grove William husbandman 595898 595898 Grove, William, of Poulet, husbandman 2
4705553 2267104 2267104 defendant Geffrey Richard husbandman 595898 595898 Geffrey, Richard, of Poulet, husbandman 0
4705563 2267109 2267109 defendant Pontessyd Walter husbandman 595898 595898 Pontessyd, Walter, of Poulet, husbandman 0
4807191 2298451 2298451 defendant Eyer William   595898 595898 Eyer, William, of Poulet 0
5098592 2386021 2386021 defendant Gatecombe Thomas husbandman 595898 595898 Gatecombe, Thomas, of Poulet, husbandman 1
5102301 2387090 2387090 defendant Hurne Philip husbandman 595898 595898 Hurne, Philip, of Poulet, husbandman 2
5187966 2412189 2412189 defendant atte Wode William husbandman 595898 595898 atte Wode, William, of Poulet, husbandman 0
5188036 2412211 2412211 defendant Radehill John husbandman 595898 595898 Radehill, John, of Poulet, husbandman 0
5290335 2442179 2442179 defendant Reynold John clerk 595898 595898 Reynold, John, of Poulet, clerk 2
5319710 2450990 2450990 defendant Horne Henry laborer 595898 595898 Horne, Henry, of Poulet, laborer 0
5337117 2456178 2456178 defendant Horne John singleman 595898 595898 Horne, John, of Poulet, husbandman, singleman 0
5387026 2471355 2471355 defendant Abrygge Roger husbandman 595898 595898 Abrygge, Roger, of Poulet, husbandman 0
5399470 2474925 2474925 defendant Alrygge Roger husbandman 595898 595898 Alrygge, Roger, of Poulet, husbandman 0
5427237 2483088 2483088 defendant Alrygge Roger husbandman 595898 595898 Alrygge, Roger, of Poulet, husbandman 0
5457736 2492210 2492210 defendant Alrygge Roger husbandman 595898 595898 Alrygge, Roger, of Poulet, husbandman 0
5528812 2513533 2513533 defendant Baldewyn Thomas husbandman 595898 595898 Baldewyn, Thomas, of Poulet, husbandman 0
5528813 2513533 2513533 defendant Baldewyn John husbandman 595898 595898 Baldewyn, John, of Poulet, husbandman 1
5528814 2513533 2513533 defendant Hurne Philip husbandman 595898 595898 Hurne, Philip, of Poulet, husbandman 2
5537163 2516107 2516107 defendant Geffrey Philip husbandman 595898 595898 Geffrey, Philip, of Poulet, husbandman 0
5606528 2536930 2536930 defendant Verman Richard husbandman 595898 595898 Verman, Richard, of Poulet, husbandman 0
5624158 2551499 2551499 defendant Clerke John husbandman 595898 595898 Clerke, John, of Poulet, husbandman 0
5624159 2551499 2551499 defendant Pontesyde Walter husbandman 595898 595898 Pontesyde, Walter, of Poulet, husbandman 1
5624160 2551499 2551499 defendant Horlocke Walter husbandman 595898 595898 Horlocke, Walter, of Poulet, husbandman 2
5624161 2551499 2551499 defendant Waleys Roger husbandman 595898 595898 Waleys, Roger, of Poulet, husbandman 3

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