names

31 rows where place_id = 593727

✎ 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
3602564 1868463 1868463 defendant Grey Henry   593727 593727 Grey, Henry, of Codnore, knight 0
3611180 1871174 1871174 plaintiff Grey Henry   593727 593727 Grey, Henry, of Codnore, knight 0
3611185 1871175 1871175 plaintiff Grey Henry   593727 593727 Grey, Henry, of Codnore, knight 0
3613104 1871751 1871751 defendant Fulwod Robert yeoman 593727 593727 Fulwod, Robert, of Codnore, yeoman 2
3625851 1875619 1875619 defendant Ferneworth Thomas yeoman 593727 593727 Ferneworth, Thomas, of Codnore, yeoman 1
3640574 1907492 1907492 defendant Zouche David gent 593727 593727 Zouche, David, of Codnore, gent 0
3640576 1907493 1907493 defendant Zouche David gent 593727 593727 Zouche, David, of Codnore, gent 0
3653100 1911300 1911300 defendant Zouche John   593727 593727 Zouche, John, of Codnore, knight 0
4501999 2201220 2201220 defendant Daucue or Dancue Adam   593727 593727 Daucue or Dancue, Adam, of Codnore 4
4713085 2269415 2269415 defendant Roberd John yeoman 593727 593727 Roberd, John, of Codnore, yeoman 0
4833099 2306371 2306371 defendant del Hay Thomas   593727 593727 del Hay, Thomas, of Codnore, servant 2
4857741 2313798 2313798 defendant Mye Richard yeoman 593727 593727 (Mye, Richard, of Codnore, yeoman 1
4859967 2314485 2314485 defendant Colvyll Thomas parker 593727 593727 Colvyll, Thomas, of Codnore, parker 0
4859969 2314485 2314485 defendant del Hay Thomas   593727 593727 del Hay, Thomas, of Codnore, servant 2
4859986 2314492 2314492 defendant del Hay Thomas   593727 593727 del Hay, Thomas, of Codnore, servant 1
4859987 2314492 2314492 defendant Colvyll Thomas parker 593727 593727 together with Colvyll, Thomas, of Codnore, parker 2
4879432 2320498 2320498 defendant Saxby Henry husbandman 593727 593727 Saxby, Henry, of Codnore, husbandman 0
4966162 2346812 2346812 defendant Bowere John laborer 593727 593727 Bowere, John, of Codnore, laborer 0
4966163 2346812 2346812 defendant Mower William husbandman 593727 593727 Mower, William, of Codnore, husbandman 1
4980923 2351230 2351230 defendant Cook Henry husbandman 593727 593727 Cook, Henry, of Codnore, husbandman 2
5002403 2357612 2357612 defendant Coke Henry husbandman 593727 593727 Coke, Henry, of Codnore, husbandman 0
5316244 2449945 2449945 defendant Synkwell Richard yeoman 593727 593727 Synkwell, Richard, of Codnore, yeoman 0
5346595 2459087 2459087 defendant Wodeborne Richard gent 593727 593727 Wodeborne, Richard, of Codnore, gent 0
5346596 2459087 2459087 defendant Sylcok Richard   593727 593727 Sylcok, Richard, of Codnore, smithy man 1
5346597 2459087 2459087 defendant Helot John husbandman 593727 593727 Helot, John, of Codnore, husbandman 2
5346598 2459087 2459087 defendant Grenesmyth John husbandman 593727 593727 Grenesmyth, John, of Codnore, husbandman 3
5346599 2459087 2459087 defendant Parsons John laborer 593727 593727 Parsons, John, of Codnore, laborer 4
5463492 2493991 2493991 defendant Grey Henry   593727 593727 together with Grey, Henry, of Codnore, knight 1
5475045 2497521 2497521 defendant Grey Herny   593727 593727 Grey, Herny, of Codnore, knight 0
5475050 2497522 2497522 defendant Grey Henry   593727 593727 Grey, Henry, of Codnore, knight 1
5534560 2515354 2515354 defendant Nicols Hugh laborer 593727 593727 Nicols, Hugh, of Codnore, laborer 9

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