names

18 rows where place_id = 705604

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4158558 2081065 2081065 defendant Payne Robert yeoman 705604 705604 Payne, Robert, of Lympenhowe, yeoman 0
4181980 2089178 2089178 defendant Payne Robert yeoman 705604 705604 Payne, Robert, of Lympenhowe, yeoman 0
4207601 2098217 2098217 defendant Payne Robert husbandman 705604 705604 Payne, Robert, of Lympenhowe, husbandman 3
4276444 2121704 2121704 defendant Ima Robert yeoman 705604 705604 Ima, Robert, of Lympenhowe, yeoman 2
4468910 2190953 2190953 defendant Wryght Edmund   705604 705604 Wryght, Edmund, of Lympenhowe 2
4606540 2233158 2233158 defendant Moux Richard   705604 705604 Moux, Richard, of Lympenhowe 0
4664033 2250238 2250238 defendant Mous or Mons Richard yeoman 705604 705604 Mous or Mons, Richard, of Lympenhowe, yeoman 0
4749292 2280270 2280270 defendant atte Lee Robert husbandman 705604 705604 atte Lee, Robert, of Lympenhowe, husbandman 10
4818338 2301819 2301819 defendant atte Lee Robert husbandman 705604 705604 atte Lee, Robert, of Lympenhowe, husbandman 0
4939277 2338668 2338668 defendant Botolf Thomas husbandman 705604 705604 Botolf, Thomas, of Lympenhowe, husbandman 1
5032355 2366341 2366341 defendant Hobert William smith 705604 705604 Hobert, William, of Lympenhowe, smith 3
5057071 2373693 2373693 defendant atte Lee John laborer 705604 705604 atte Lee, John, of Lympenhowe, laborer 1
5093048 2384356 2384356 defendant Havell or Hanell John husbandman 705604 705604 Havell or Hanell, John, of Lympenhowe, husbandman 0
5094084 2384670 2384670 defendant Caerles Robert   705604 705604 Caerles, Robert, of Lympenhowe 2
5148392 2400664 2400664 defendant Doraunt Robert laborer 705604 705604 Doraunt, Robert, of Lympenhowe, laborer 10
5167680 2406269 2406269 defendant Doraunt Robert laborer 705604 705604 Doraunt, Robert, of Lympenhowe, laborer 10
5395541 2473804 2473804 defendant Came William husbandman 705604 705604 Came, William, of Lympenhowe, husbandman 4
5408830 2477602 2477602 defendant Canne William husbandman 705604 705604 Canne, William, of Lympenhowe, husbandman 4

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