names

48 rows where place_id = 592171

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606824 1869804 1869804 defendant Flykke Thomas, senior husbandman 592171 592171 Flykke, Thomas, senior, of Rumburgh, husbandman 2
3606894 1869821 1869821 defendant Flykke Thomas husbandman 592171 592171 Flykke, Thomas, of Rumburgh, husbandman 0
3723196 1933525 1933525 defendant Bolytowte John husbandman 592171 592171 Bolytowte, John, of Rumburgh, husbandman 1
3761741 1945683 1945683 defendant Heyron Thomas laborer 592171 592171 Heyron, Thomas, of Rumburgh, laborer 0
3846065 1972328 1972328 defendant Carvell John husbandman 592171 592171 Carvell, John, of Rumburgh, husbandman 1
3943190 2004742 2004742 plaintiff Aldrich Richard gent 592171 592171 Aldrich, Richard, of Rumburgh, gent 0
3943191 2004742 2004742 defendant Bataly Edmund husbandman 592171 592171 Bataly, Edmund, of Rumburgh, husbandman 0
3943193 2004742 2004742 defendant Bataly Nicholas laborer 592171 592171 Bataly, Nicholas, of Rumburgh, laborer 2
3943194 2004742 2004742 defendant Grigge Henry laborer 592171 592171 Grigge, Henry, of Rumburgh, laborer 3
3943195 2004742 2004742 defendant Gibson Christopher laborer 592171 592171 Gibson, Christopher, of Rumburgh, laborer 4
3943196 2004742 2004742 defendant Aleyn Henry laborer 592171 592171 Aleyn, Henry, of Rumburgh, laborer 5
3965925 2012701 2012701 defendant Wood Edward yeoman 592171 592171 Wood, Edward, of Rumburgh, yeoman 1
4691890 2262998 2262998 defendant Flykke Thomas chandler 592171 592171 Flykke, Thomas, of Rumburgh, chandler 0
4700820 2265656 2265656 defendant Alryche William   592171 592171 Alryche, William, of Rumburgh, pedlar 0
4735989 2276401 2276401 defendant Caumbrigge John chaplain 592171 592171 Caumbrigge, John, of Rumburgh, chaplain 1
4886663 2322692 2322692 defendant Chase Thomas laborer 592171 592171 Chase, Thomas, of Rumburgh, laborer 1
4920007 2332768 2332768 defendant Gooceh Robert husbandman 592171 592171 Gooceh, Robert, of Rumburgh, husbandman 4
4987959 2353367 2353367 defendant Flykke Thomas chandler 592171 592171 Flykke, Thomas, of Rumburgh, chandler 0
5131026 2395560 2395560 defendant Whytyng Peter yeoman 592171 592171 Whytyng, Peter, of Rumburgh, yeoman 0
5150532 2401295 2401295 defendant Whytyng Peter yeoman 592171 592171 Whytyng, Peter, of Rumburgh, yeoman 0
5186066 2411673 2411673 defendant Whytyng Peter yeoman 592171 592171 Whytyng, Peter, of Rumburgh, yeoman 0
5205055 2417234 2417234 defendant Whytyng Peter yeoman 592171 592171 Whytyng, Peter, of Rumburgh, yeoman 0
5234495 2425678 2425678 defendant Flykke Thomas yeoman 592171 592171 Flykke, Thomas, of Rumburgh, yeoman 0
5260810 2433502 2433502 defendant Flykke Thomas yeoman 592171 592171 Flykke, Thomas, of Rumburgh, yeoman 0
5277002 2438355 2438355 defendant Lounde Robert husbandman 592171 592171 Lounde, Robert, of Rumburgh, husbandman 0
5277003 2438355 2438355 defendant Gryggys William smith 592171 592171 Gryggys, William, of Rumburgh, smith 1
5280883 2439482 2439482 defendant Lounde Robert husbandman 592171 592171 Lounde, Robert, of Rumburgh, husbandman 0
5280884 2439482 2439482 defendant Gryggys William smith 592171 592171 Gryggys, William, of Rumburgh, smith 1
5284901 2440605 2440605 defendant Lounde Robert husbandman 592171 592171 Lounde, Robert, of Rumburgh, husbandman 2
5284902 2440605 2440605 defendant Gryggys William smith 592171 592171 Gryggys, William, of Rumburgh, smith 3
5284903 2440605 2440605 defendant Flyk Thomas husbandman 592171 592171 Flyk, Thomas, of Rumburgh, husbandman 4
5284904 2440605 2440605 defendant Cosyn or Cofyn Richard husbandman 592171 592171 Cosyn or Cofyn, Richard, of Rumburgh, husbandman 5
5310654 2448223 2448223 defendant Gryggys William smith 592171 592171 Gryggys, William, of Rumburgh, smith 1
5320976 2451366 2451366 defendant Flykke Thomas husbanman 592171 592171 Flykke, Thomas, of Rumburgh, husbanman 0
5332002 2454645 2454645 defendant Gryggys William smith 592171 592171 Gryggys, William, of Rumburgh, smith 1
5332003 2454645 2454645 defendant Gryggys John smith 592171 592171 Gryggys, John, of Rumburgh, smith 2
5355989 2461956 2461956 plaintiff Laurens John yeoman 592171 592171 Laurens, John, of Rumburgh, yeoman 0
5355990 2461956 2461956 defendant Whytyng Peter husbandman 592171 592171 Whytyng, Peter, of Rumburgh, husbandman 0
5411980 2478535 2478535 defendant Laurens John yeoman 592171 592171 Laurens, John, of Rumburgh, yeoman 13
5426528 2482879 2482879 defendant Laurens John yeoman 592171 592171 together with Laurens, John, of Rumburgh, yeoman 11
5512730 2508838 2508838 defendant Aldrych John husbandman 592171 592171 Aldrych, John, of Rumburgh, husbandman 0
5534156 2515216 2515216 defendant Aldryche Robert laborer 592171 592171 Aldryche, Robert, of Rumburgh, laborer 0
5534157 2515216 2515216 defendant Aldryche Richard laborer 592171 592171 Aldryche, Richard, of Rumburgh, laborer 1
5546055 2518840 2518840 defendant Tybold William husbandman 592171 592171 Tybold, William, of Rumburgh, husbandman 0
5546057 2518841 2518841 defendant Tybold William husbandman 592171 592171 Tybold, William, of Rumburgh, husbandman 0
5563894 2524052 2524052 defendant Spachet Geoffrey laborer 592171 592171 Spachet, Geoffrey, of Rumburgh, laborer 2
5563895 2524052 2524052 defendant Tebald Thomas laborer 592171 592171 Tebald, Thomas, of Rumburgh, laborer 3
5588266 2531333 2531333 defendant Sellyng Richard husbandman 592171 592171 Sellyng, Richard, of Rumburgh, husbandman 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);