names

32 rows where place_id = 607830

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670961 1916888 1916888 defendant Ryche William husbandman 607830 607830 Ryche, William, of Lexden, husbandman 0
4110582 2064044 2064044 defendant Sawen John (legal representative) 607830 607830 Sawen, John, of Lexden, gent, administratrix of 0
4110583 2064044 2064044 defendant Sawen Elizabeth widow 607830 607830 Sawen, Elizabeth, of Lexden, widow 1
4238810 2109196 2109196 defendant Twede William yeoman 607830 607830 Twede, William, of Lexden, liberty of Colchester, yeoman 0
4276232 2121630 2121630 defendant Weston Nicholas gent 607830 607830 Weston, Nicholas, of Lexden, or of Alpheston, gent 0
4372531 2155245 2155245 defendant Mulbery David laborer 607830 607830 Mulbery, David, of Lexden, laborer 2
4601553 2231710 2231710 defendant Cok John   607830 607830 Cok, John, of Lexden, bailiff 1
4772527 2287373 2287373 defendant Salman John miller 607830 607830 Salman, John, of Lexden, miller 0
4795445 2294727 2294727 defendant Boteler Walter gent 607830 607830 Boteler, Walter, of Lexden, yeoman, mainpernors for Spyce, Richard, of Lexden, gent 2
4829586 2305295 2305295 defendant Cumbyrlowe John yeoman 607830 607830 Cumbyrlowe, John, of Lexden, yeoman 0
4859738 2314411 2314411 defendant Dytton William husbandman 607830 607830 Dytton, William, of Lexden, husbandman 0
4877399 2319886 2319886 defendant Boteler Walter yeoman 607830 607830 Boteler, Walter, of Lexden, yeoman 3
4986198 2352799 2352799 defendant Billeston Walter yeoman 607830 607830 Billeston, Walter, of Lexden, yeoman 0
4994366 2355189 2355189 defendant Bylston Walter yeoman 607830 607830 Bylston, Walter, of Lexden, yeoman 0
5044639 2370028 2370028 plaintiff Bernon William   607830 607830 Bernon, William, of Lexden 2
5074227 2378779 2378779 defendant Bylston Walter   607830 607830 Bylston, Walter, of Lexden, bailiff 0
5088262 2382942 2382942 defendant Oras John husbandman 607830 607830 Oras, John, of Lexden, husbandman 0
5088263 2382942 2382942 defendant Tyler John laborer 607830 607830 Tyler, John, of Lexden, laborer 1
5088264 2382942 2382942 defendant Oras Thomas laborer 607830 607830 Oras, Thomas, of Lexden, laborer 2
5088265 2382942 2382942 defendant Wylegh John fuller 607830 607830 Wylegh, John, of Lexden, fuller 3
5236873 2426367 2426367 defendant Busshe John husbandman 607830 607830 Busshe, John, of Lexden, husbandman 0
5236874 2426367 2426367 defendant Knyght John   607830 607830 Knyght, John, of Lexden, wheelwright 1
5355012 2461637 2461637 defendant Sutton William husbandman 607830 607830 Sutton, William, of Lexden, husbandman 1
5355631 2461836 2461836 defendant Pyper John husbandman 607830 607830 Pyper, John, of Lexden, husbandman 3
5376884 2468365 2468365 defendant Souter Nicholas husbandman 607830 607830 Souter, Nicholas, of Lexden, husbandman 0
5406896 2477037 2477037 defendant Mountford Robert husbandman 607830 607830 Mountford, Robert, of Lexden, husbandman 0
5420041 2480912 2480912 defendant Mountford Robert husbandman 607830 607830 Mountford, Robert, of Lexden, husbandman 0
5537954 2516364 2516364 defendant Orays Richard husbandman 607830 607830 Orays, Richard, of Lexden, husbandman 1
5544011 2518236 2518236 defendant Motte Geoffrey husbandman 607830 607830 Motte, Geoffrey, of Lexden, husbandman 1
5544012 2518236 2518236 defendant Motte William husbandman 607830 607830 Motte, William, of Lexden, husbandman 2
5544752 2518470 2518470 defendant Clerke John husbandman 607830 607830 Clerke, John, of Lexden, husbandman 2
5550902 2520296 2520296 defendant Gybbes Isabel Roger 607830 607830 Gybbes, Isabel, of Lexden, widow, former wife of Lychefeld, Roger 0

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