names

28 rows where place_id = 599017

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634879 1905709 1905709 defendant Cormonger Robert yeoman 599017 599017 Cormonger, Robert, of Kelsey, yeoman 0
3634881 1905710 1905710 defendant Cormonger Robert yeoman 599017 599017 Cormonger, Robert, of Kelsey, yeoman 0
3907263 1992720 1992720 defendant Wylson James tailor 599017 599017 Wylson, James, of Kelsey, tailor 1
3972880 2015087 2015087 defendant Rychardson Richard husbandman 599017 599017 Rychardson, Richard, of Kelsey, husbandman 0
4085834 2055208 2055208 defendant Pryste Thomas butcher 599017 599017 Pryste, Thomas, of Kelsey, butcher 2
4148480 2077597 2077597 defendant Adcok William yeoman 599017 599017 Adcok, William, of Kelsey, yeoman 1
4148481 2077597 2077597 defendant Fordham Richard yeoman 599017 599017 Fordham, Richard, of Kelsey, yeoman 2
4148909 2077737 2077737 defendant Bynney Richard yeoman 599017 599017 Bynney, Richard, of Kelsey, yeoman 0
4162869 2082542 2082542 defendant Wyllymott James gent 599017 599017 Wyllymott, James, of Kelsey, gent 55
4171264 2085411 2085411 defendant Crowther Richard husbandman 599017 599017 Crowther, Richard, of Kelsey, husbandman 0
4174077 2086387 2086387 defendant Cooke John laborer 599017 599017 Cooke, John, of Kelsey, laborer 1
4174084 2086389 2086389 defendant Cocke John laborer 599017 599017 Cocke, John, of Kelsey, laborer 1
4183539 2089725 2089725 defendant Fordham Richard yeoman 599017 599017 Fordham, Richard, of Kelsey, yeoman 0
4183540 2089725 2089725 defendant Adcocke William yeoman 599017 599017 Adcocke, William, of Kelsey, yeoman 1
4190294 2092114 2092114 defendant Fordam Christopher yeoman 599017 599017 Fordam, Christopher, of Kelsey, yeoman 0
4193033 2093131 2093131 defendant Ascough Francis gent 599017 599017 Ascough, Francis, of Kelsey, gent 1
4219645 2102374 2102374 defendant Adcock William yeoman 599017 599017 Adcock, William, of Kelsey, yeoman 3
4219650 2102375 2102375 defendant Adcock William yeoman 599017 599017 Adcock, William, of Kelsey, yeoman 3
4232052 2106710 2106710 defendant Cater John gent 599017 599017 Cater, John, of Kelsey, gent 0
4289122 2126166 2126166 defendant Crowder William clerk 599017 599017 Crowder, William, of Kelsey, clerk 2
4359707 2150630 2150630 defendant Hides John shoemaker 599017 599017 Hides, John, of Kelsey, shoemaker 3
4443560 2182951 2182951 defendant Feriby Peter de   599017 599017 Feriby, Peter de, of Kelsey 0
4488338 2197071 2197071 plaintiff Stepyng Robert   599017 599017 Stepyng, Robert, of Kelsey 0
4508114 2203012 2203012 defendant Wright Roger   599017 599017 Wright, Roger, of Kelsey 2
4524295 2207935 2207935 defendant Smyth John   599017 599017 Smyth, John, of Kelsey 3
5021565 2363204 2363204 defendant Testour Thomas husbandman 599017 599017 Testour, Thomas, of Kelsey, husbandman 0
5585435 2530514 2530514 plaintiff Hygdon Thomas (legal representative) 599017 599017 Hygdon, Thomas, of Kelsey, executor of 0
5595941 2533639 2533639 defendant Williams John husbandman 599017 599017 Williams, John, of Kelsey, husbandman 1

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