names

18 rows where case_id = 2007275

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3950568 2007275 2007275 plaintiff Garnauns William gent   Garnauns, William, gent 0
3950569 2007275 2007275 defendant Higgyns Jenkin yeoman 658975 658975 Higgyns, Jenkin, of Wyeforton, yeoman 0
3950570 2007275 2007275 defendant Androws Christopher clerk 611082 611082 Androws, Christopher, of Castle Frome, clerk 1
3950571 2007275 2007275 defendant Rogers John husbandman 589864 589864 Rogers, John, of Magna Byrche, husbandman 2
3950572 2007275 2007275 defendant Bond Richard yeoman 586459 586459 Bond, Richard, of Stoke juxta Leomyster, yeoman 3
3950573 2007275 2007275 defendant Hyde Peter husbandman 658977 658977 Hyde, Peter, of Stoke Blysse, Worcs, husbandman 4
3950574 2007275 2007275 defendant Dones John husbandman 658978 658978 Dones, John, of Dymmocke, Glos, husbandman 5
3950575 2007275 2007275 defendant Cooke Richard Powell husbandman 658979 658979 Cooke, Richard Powell, of Lycewen, Brecon, husbandman 6
3950576 2007275 2007275 defendant Churche Thomas mercer 586208 586208 Churche, Thomas, of Hereford, mercer 7
3950577 2007275 2007275 defendant Phillipps John yeoman 658969 658969 Phillipps, John, of Churcham, Glos, yeoman 8
3950578 2007275 2007275 defendant Esbache John husbandman 658970 658970 Esbache, John, of Kennersley, husbandman 9
3950579 2007275 2007275 defendant James Thomas husbandman 658980 658980 James, Thomas, of Tryxton, husbandman 10
3950580 2007275 2007275 defendant ap Richard David Lloyd clerk 658981 658981 ap Richard, David Lloyd, of Longtown, clerk 11
3950581 2007275 2007275 defendant Waters Thomas David husbandman 600182 600182 Waters, Thomas David, of Dorston, husbandman 12
3950582 2007275 2007275 defendant Hunt Eleanor widow 658973 658973 Hunt, Eleanor, of Snodell, widow 13
3950583 2007275 2007275 defendant Browne Richard clerk 600753 600753 Browne, Richard, of Bredwardyne, clerk 14
3950584 2007275 2007275 defendant Dansey Bartholomew gent 592497 592497 Dansey, Bartholomew, of Marston, gent 15
3950585 2007275 2007275 defendant Hethe John yeoman 640907 640907 Hethe, John, of Monkeland, yeoman 16

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