names

21 rows where case_id = 2416595

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5202832 2416595 2416595 plaintiff Byeston Richard     Byeston, Richard 0
5202833 2416595 2416595 defendant Crakke Thomas yeoman 798628 798628 Crakke, Thomas, of Kimbolton, Hunts, yeoman 0
5202834 2416595 2416595 defendant Bowlast Thomas yeoman 859028 859028 Bowlast, Thomas, of Kimbolton, Cambs, yeoman 1
5202835 2416595 2416595 defendant Baret Thomas yeoman 597745 597745 Baret, Thomas, of Kymbolton, yeoman 2
5202836 2416595 2416595 defendant Fyssher John   597745 597745 Fyssher, John, of Kymbolton, glove maker 3
5202837 2416595 2416595 defendant Walsshman Roger yeoman 859030 859030 Walsshman, Roger, of Kymbolton, Cambs, yeoman 4
5202838 2416595 2416595 defendant Mynt Thomas yeoman 596992 596992 Mynt, Thomas, of Kymbalton, yeoman 5
5202839 2416595 2416595 defendant Crakke Henry yeoman 596992 596992 Crakke, Henry, of Kymbalton, yeoman 6
5202840 2416595 2416595 defendant Rysley Richard yeoman 596992 596992 Rysley, Richard, of Kymbalton, yeoman 7
5202841 2416595 2416595 defendant Bowlast Richard St Neots, yeoman   Bowlast, Richard, St Neots, yeoman 8
5202842 2416595 2416595 defendant Chapman John jun, of St Neots, mercer   Chapman, John, jun, of St Neots, mercer 9
5202843 2416595 2416595 defendant Grene William tailor 594218 594218 Grene, William, of St Neots, tailor 10
5202844 2416595 2416595 defendant Stacy Thomas yeoman 594218 594218 Stacy, Thomas, of St Neots, yeoman 11
5202845 2416595 2416595 defendant Corbryk John tailor 594218 594218 Corbryk, John, of St Neots, tailor 12
5202846 2416595 2416595 defendant Gore John husbandman 859031 859031 Gore, John, of Great Paxston, husbandman 13
5202847 2416595 2416595 defendant Neve Roger carpenter 774517 774517 Neve, Roger, of Great Paxton, carpenter 14
5202848 2416595 2416595 defendant smyth Thomas husbandman 859032 859032 smyth, Thomas, of Haroweston, husbandman 15
5202849 2416595 2416595 defendant Lambe Thomas husbandman 859033 859033 Lambe, Thomas, of Hardewyk by Awnsley, husbandman 16
5202850 2416595 2416595 defendant Boteler John yeoman 754121 754121 Boteler, John, of Lyttelyngton, yeoman 17
5202851 2416595 2416595 defendant Pynke John yeoman 754121 754121 Pynke, John, of Lyttelyngton, yeoman 18
5202852 2416595 2416595 defendant Turpyn John laborer 859034 859034 Turpyn, John, of Basyngbe, laborer 19

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