names

18 rows where case_id = 2007274

✎ 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
3950550 2007274 2007274 plaintiff Garnans William gent   Garnans, William, gent 0
3950551 2007274 2007274 defendant Hyggyns Jenkin yeoman 658967 658967 Hyggyns, Jenkin, of Wytforton, yeoman 0
3950552 2007274 2007274 defendant Androws Christopher clerk 611083 611083 Androws, Christopher, of Castell Frome, clerk 1
3950553 2007274 2007274 defendant Rogers John husbandman 589864 589864 Rogers, John, of Magna Byrche, husbandman 2
3950554 2007274 2007274 defendant Bond Richard yeoman 586459 586459 Bond, Richard, of Stoke juxta Leomynster, yeoman 3
3950555 2007274 2007274 defendant Hyde Peter of Stoke Blysse Worcs, husbandman   Hyde, Peter of Stoke Blysse, Worcs, husbandman 4
3950556 2007274 2007274 defendant Dones or Doves John husbandman 619372 619372 Dones or Doves, John, of Dymmoke, Glos, husbandman 5
3950557 2007274 2007274 defendant Coke Richard Powell husbandman 658968 658968 Coke, Richard Powell, of Lypewen, Brecon, husbandman 6
3950558 2007274 2007274 defendant Churche Thomas mercer 586208 586208 Churche, Thomas, of Hereford, mercer 7
3950559 2007274 2007274 defendant Phillipps John yeoman 658969 658969 Phillipps, John, of Churcham, Glos, yeoman 8
3950560 2007274 2007274 defendant Esbache John husbandman 658970 658970 Esbache, John, of Kennersley, husbandman 9
3950561 2007274 2007274 defendant James Thomas husbandman 658971 658971 James, Thomas, of Truxton, husbandman 10
3950562 2007274 2007274 defendant ap Richard David Lloyd clerk 658972 658972 ap Richard, David Lloyd, of Longaville, clerk 11
3950563 2007274 2007274 defendant Waters Thomas husbandman 600182 600182 Waters, Thomas, of Dorston, husbandman 12
3950564 2007274 2007274 defendant Hunt Eleanor widow 658973 658973 Hunt, Eleanor, of Snodell, widow 13
3950565 2007274 2007274 defendant Browne John clerk 600753 600753 Browne, John, of Bredwardyne, clerk 14
3950566 2007274 2007274 defendant Dansey Bartholomew gent 658974 658974 Dansey, Bartholomew, of Marston, Glos, gent 15
3950567 2007274 2007274 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);