names

28 rows where place_id = 600868

✎ 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
3642899 1908229 1908229 defendant Edlyn John collier 600868 600868 Edlyn, John, of Keldon, collier 0
3705011 1927860 1927860 defendant Bocher John butcher 600868 600868 Bocher, John, of Keldon, butcher 1
3729488 1935469 1935469 defendant Knyght John butcher 600868 600868 Knyght, John, of Keldon, butcher 2
3865616 1978718 1978718 defendant Grene Richard yeoman 600868 600868 Grene, Richard, of Keldon, yeoman 0
3976251 2016262 2016262 defendant Wright John yeoman 600868 600868 Wright, John, of Keldon, yeoman 0
3976252 2016262 2016262 defendant Makyn Thomas husbandman 600868 600868 Makyn, Thomas, of Keldon, husbandman 1
3976253 2016262 2016262 defendant Notte Richard husbandman 600868 600868 Notte, Richard, of Keldon, husbandman 2
3976254 2016262 2016262 defendant Lincolne Richard husbandman 600868 600868 Lincolne, Richard, of Keldon, husbandman 3
3976255 2016262 2016262 defendant Lorde Thomas yeoman 600868 600868 Lorde, Thomas, of Keldon, yeoman 4
4067809 2048799 2048799 defendant Haryson John smith 600868 600868 Haryson, John, of Keldon, smith 1
4067810 2048799 2048799 defendant Marden John husbandman 600868 600868 Marden, John, of Keldon, husbandman 2
4154814 2079779 2079779 defendant Aburforde William yeoman 600868 600868 Aburforde, William, of Keldon, yeoman 0
4401217 2165002 2165002 defendant Marden Nathaniel smith 600868 600868 Marden, Nathaniel, of Keldon, smith 0
4776469 2288634 2288634 defendant Smyth alias Drover John drover 600868 600868 Smyth alias Drover, John, of Keldon, drover 0
5118800 2391930 2391930 defendant Felyx Stephen husbandman 600868 600868 Felyx, Stephen, of Keldon, husbandman 1
5136542 2397203 2397203 defendant Clerk John   600868 600868 Clerk, John, of Keldon, inn holder 0
5236986 2426401 2426401 defendant Wryght Margaret widow 600868 600868 Wryght, Margaret, of Keldon, widow 7
5491963 2502505 2502505 defendant Clerk John husbandman 600868 600868 Clerk, John, of Keldon, husbandman 3
5581837 2529398 2529398 defendant Pake John yeoman 600868 600868 Pake, John, of Keldon, yeoman 0
5586327 2530766 2530766 defendant Marler Stephen yeoman 600868 600868 Marler, Stephen, of Keldon, yeoman 0
5586328 2530766 2530766 defendant Cheseman John laborer 600868 600868 Cheseman, John, of Keldon, laborer 1
5589538 2531728 2531728 defendant Strutte William fuller 600868 600868 Strutte, William, of Keldon, fuller 0
5589539 2531728 2531728 defendant Marler Stephen yeoman 600868 600868 Marler, Stephen, of Keldon, yeoman 1
5589540 2531728 2531728 defendant Barker John laborer 600868 600868 Barker, John, of Keldon, laborer 2
5589541 2531728 2531728 defendant Barbour Stephen butcher 600868 600868 Barbour, Stephen, of Keldon, butcher 3
5589542 2531728 2531728 defendant Cheseman William laborer 600868 600868 Cheseman, William, of Keldon, laborer 4
5589543 2531728 2531728 defendant Sponer John laborer 600868 600868 Sponer, John, of Keldon, laborer 5
5589544 2531728 2531728 defendant Becham John tailor 600868 600868 Becham, John, of Keldon, tailor 6

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