names

25 rows where place_id = 592869

✎ 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
3609206 1870540 1870540 defendant Thorn John husbandman 592869 592869 Thorn, John, of Kyngesdon, husbandman 3
3850231 1973664 1973664 plaintiff Menstyche John (legal representative) 592869 592869 Menstyche, John, of Kyngesdon, clerk, executor of 0
3915794 1995661 1995661 plaintiff Dollyng John husbandman 592869 592869 Dollyng, John, of Kyngesdon, husbandman 0
3934299 2001769 2001769 defendant Careman Thomas husbandman 592869 592869 Careman, Thomas, of Kyngesdon, husbandman 2
3934306 2001771 2001771 defendant Calewaye William husbandman 592869 592869 Calewaye, William, of Kyngesdon, husbandman 2
3934307 2001771 2001771 defendant Andrew John husbandman 592869 592869 Andrew, John, of Kyngesdon, husbandman 3
3934324 2001775 2001775 defendant Brownyng Thomas yeoman 592869 592869 Brownyng, Thomas, of Kyngesdon, yeoman 1
3934325 2001775 2001775 defendant Master John husbandman 592869 592869 Master, John, of Kyngesdon, husbandman 2
3934326 2001775 2001775 defendant Tomsye Richard husbandman 592869 592869 Tomsye, Richard, of Kyngesdon, husbandman 3
3964634 2012237 2012237 defendant Horde Thomas husbandman 592869 592869 Horde, Thomas, of Kyngesdon, husbandman 0
3989644 2021040 2021040 defendant Salway or Salley John husbandman 592869 592869 Salway or Salley, John, of Kyngesdon, husbandman 0
4040559 2039117 2039117 defendant Hurde Thomas yeoman 592869 592869 Hurde, Thomas, of Kyngesdon, yeoman 0
4056477 2044700 2044700 defendant Carman John husbandman 592869 592869 Carman, John, of Kyngesdon, husbandman 2
4073666 2050874 2050874 defendant Dade Richard yeoman 592869 592869 Dade, Richard, of Kyngesdon, yeoman 0
4464576 2189589 2189589 defendant Hibrok Alexander   592869 592869 Hibrok, Alexander, of Kyngesdon 1
4568391 2221684 2221684 defendant Chepstede Robert   592869 592869 Chepstede, Robert, of Kyngesdon 1
4589868 2228194 2228194 defendant Chepstede Richard   592869 592869 Chepstede, Richard, of Kyngesdon 3
4856031 2313258 2313258 defendant Dobbeson Robert husbandman 592869 592869 Dobbeson, Robert, of Kyngesdon, husbandman 2
4860435 2314629 2314629 defendant Haukyn Edmund yeoman 592869 592869 Haukyn, Edmund, of Kyngesdon, yeoman 1
4935332 2337449 2337449 defendant Cacot William smith 592869 592869 Cacot, William, of Kyngesdon, smith 2
5016565 2361739 2361739 defendant Lovelas Richard gent 592869 592869 Lovelas, Richard, of Kyngesdon, gent 0
5016586 2361745 2361745 defendant Lovelas Richard gent 592869 592869 Lovelas, Richard, of Kyngesdon, gent 0
5016591 2361746 2361746 defendant Lovelas Richard gent 592869 592869 Lovelas, Richard, of Kyngesdon, gent 0
5099600 2386319 2386319 defendant Pyleman John husbandman 592869 592869 Pyleman, John, of Kyngesdon, husbandman 2
5591172 2532216 2532216 defendant Hylles Thomas yeoman 592869 592869 Hylles, Thomas, of Kyngesdon, yeoman 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);