names

33 rows where place_id = 649773

✎ 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
3908413 1993110 1993110 defendant Borowe Arthur yeoman 649773 649773 Borowe, Arthur, of Lupton, yeoman 0
3908414 1993110 1993110 defendant More Stephen yeoman 649773 649773 More, Stephen, of Lupton, yeoman 1
3938792 2003312 2003312 defendant Tolson John husbandman 649773 649773 Tolson, John, of Lupton, husbandman 5
4257595 2115515 2115515 defendant Thompson William, senior yeoman 649773 649773 Thompson, William, senior, of Lupton, yeoman 0
4257596 2115515 2115515 defendant Thompson George yeoman 649773 649773 Thompson, George, of Lupton, yeoman 1
4257597 2115515 2115515 defendant Thompson John yeoman 649773 649773 Thompson, John, of Lupton, yeoman 2
4257598 2115515 2115515 defendant Burrowe Edward yeoman 649773 649773 Burrowe, Edward, of Lupton, yeoman 3
4311550 2134178 2134178 defendant Burrowe Peter yeoman 649773 649773 Burrowe, Peter, of Lupton, yeoman 3
4311644 2134215 2134215 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 2
4311645 2134215 2134215 defendant Tayler John husbandman 649773 649773 Tayler, John, of Lupton, husbandman 3
4338494 2143215 2143215 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 0
4351997 2147933 2147933 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 0
4361774 2151369 2151369 defendant Burrowe Arthur husbandman 649773 649773 Burrowe, Arthur, of Lupton, husbandman 2
4361775 2151369 2151369 defendant Langrigge Nicholas husbandman 649773 649773 Langrigge, Nicholas, of Lupton, husbandman 3
4369817 2154260 2154260 defendant Huetson James yeoman 649773 649773 Huetson, James, of Lupton, yeoman 3
4369822 2154261 2154261 defendant Langrigge Nicholas husbandman 649773 649773 Langrigge, Nicholas, of Lupton, husbandman 3
4370317 2154440 2154440 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 2
4370318 2154440 2154440 defendant Walker Christopher glover 649773 649773 Walker, Christopher, of Lupton, husbandman, glover 3
4382328 2158790 2158790 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 0
4387472 2160455 2160455 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 0
4387473 2160455 2160455 defendant Rigg Roland husbandman 649773 649773 Rigg, Roland, of Lupton, husbandman 1
4387474 2160455 2160455 defendant Gibbonson Margaret widow 649773 649773 Gibbonson, Margaret, of Lupton, widow 2
4387475 2160455 2160455 defendant Warde William husbandman 649773 649773 Warde, William, of Lupton, husbandman 3
4390781 2161530 2161530 defendant Burrowe William husbandman 649773 649773 Burrowe, William, of Lupton, husbandman 0
4392333 2162063 2162063 defendant Midleton Christopher husbandman 649773 649773 Midleton, Christopher, of Lupton, husbandman 1
4398864 2164202 2164202 defendant Warde William husbandman 649773 649773 Warde, William, of Lupton, husbandman 0
4670524 2256456 2256456 defendant Redmayn Roger de yeoman 649773 649773 Redmayn, Roger de, of Lupton, yeoman 4
4797743 2295473 2295473 defendant Whitwell William husbandman 649773 649773 Whitwell, William, of Lupton, husbandman 5
4797793 2295484 2295484 defendant Whitwell William husbandman 649773 649773 Whitwell, William, of Lupton, husbandman 5
4926669 2334761 2334761 defendant Graunger Robert laborer 649773 649773 Graunger, Robert, of Lupton, laborer 1
5053459 2372638 2372638 defendant Heybergh Gilbert yeoman 649773 649773 Heybergh, Gilbert, of Lupton, yeoman 2
5097581 2385723 2385723 defendant Jenetson Robert husbandman 649773 649773 Jenetson, Robert, of Lupton, husbandman 0
5359489 2463002 2463002 defendant Manser Giles yeoman 649773 649773 Manser, Giles, of Lupton, yeoman 0

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