names

38 rows where place_id = 763746

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4500123 2200680 2200680 plaintiff Houghson Thomas   763746 763746 Houghson, Thomas, of Thirnyng 0
4556721 2218036 2218036 defendant Fornfeld Thomas   763746 763746 Fornfeld, Thomas, of Thirnyng 0
4572096 2222829 2222829 defendant Sheperd John   763746 763746 Sheperd, John, of Thirnyng 6
4664585 2250404 2250404 defendant Tolle Robert husbandman 763746 763746 Tolle, Robert, of Thirnyng, husbandman 0
4713982 2269702 2269702 defendant Plesaunt John   763746 763746 Plesaunt, John, of Thirnyng, mason 0
4752033 2281086 2281086 defendant Colyns John yeoman 763746 763746 Colyns, John, of Thirnyng, yeoman 4
4776615 2288679 2288679 defendant Colyns John yeoman 763746 763746 Colyns, John, of Thirnyng, yeoman 0
4783654 2290904 2290904 defendant Ronden ot Rouden William husbandman 763746 763746 Ronden ot Rouden, William, of Thirnyng, husbandman 0
4796795 2295148 2295148 defendant Colyns John   763746 763746 Colyns, John, of Thirnyng, bailiff 1
4805075 2297789 2297789 defendant Colyns John yeoman 763746 763746 Colyns, John, of Thirnyng, yeoman 1
4858195 2313932 2313932 defendant Colyne John husbandman 763746 763746 Colyne, John, of Thirnyng, husbandman 0
4861720 2315036 2315036 defendant Colynys John husbandman 763746 763746 Colynys, John, of Thirnyng, husbandman 0
4872630 2318391 2318391 defendant Tolle Simon carpenter 763746 763746 Tolle, Simon, of Thirnyng, carpenter 0
4872631 2318391 2318391 defendant Pleasaunt John   763746 763746 Pleasaunt, John, of Thirnyng, mason 1
4872632 2318391 2318391 defendant Cavelowe Thomas yeoman 763746 763746 Cavelowe, Thomas, of Thirnyng, yeoman 2
4885130 2322240 2322240 defendant Neuton Thomas   763746 763746 Neuton, Thomas, of Thirnyng 0
4900142 2326670 2326670 defendant Tolle Simon laborer 763746 763746 Tolle, Simon, of Thirnyng,, laborer 1
4942057 2339498 2339498 defendant Neweton Thomas yeoman 763746 763746 Neweton, Thomas, of Thirnyng, yeoman 0
4949882 2341941 2341941 defendant Neweton Thomas husbandman 763746 763746 Neweton, Thomas, of Thirnyng, husbandman 16
4989939 2353899 2353899 defendant Clerk Alan yeoman 763746 763746 Clerk, Alan, of thirnyng, yeoman 0
5075176 2379072 2379072 defendant Neuton Thomas husbandman 763746 763746 Neuton, Thomas, of Thirnyng, husbandman 8
5085416 2382123 2382123 defendant Neuton Thomas yeoman 763746 763746 Neuton, Thomas, of Thirnyng, yeoman 7
5089641 2383345 2383345 defendant Fornefeld Thomas husbandman 763746 763746 Fornefeld, Thomas,of Thirnyng, husbandman 0
5099977 2386430 2386430 defendant Neuton Thomas yeoman 763746 763746 Neuton, Thomas, of Thirnyng, yeoman 1
5100759 2386646 2386646 defendant Hone- or Hove- John husbandman 763746 763746 Hone- or Hove-, John, of Thirnyng, husbandman 0
5110890 2389582 2389582 defendant Cady Roger carpenter 763746 763746 Cady, Roger, of Thirnyng, carpenter 2
5110894 2389583 2389583 defendant Cady Roger carpenter 763746 763746 Cady, Roger, of Thirnyng, carpenter 2
5124217 2393540 2393540 defendant Otryngham Richard clerk 763746 763746 Otryngham, Richard, of Thirnyng, clerk 0
5170592 2407120 2407120 defendant Norwich Thomas yeoman 763746 763746 Norwich, Thomas, of Thirnyng, yeoman 1
5188373 2412313 2412313 defendant Norwich Thomas yeoman 763746 763746 Norwich, Thomas, of Thirnyng, yeoman 0
5307140 2447135 2447135 defendant Alden Robert husbandman 763746 763746 Alden, Robert, of Thirnyng, husbandman 1
5366636 2465216 2465216 defendant Fornefeld William Alderman 763746 763746 Fornefeld, William, of Thirnyng, gent, son & heir of Walter Fornefeld, of Norwich, Alderman 0
5387583 2471517 2471517 plaintiff Fornfeld John   763746 763746 Fornfeld, John, of Thirnyng 0
5413181 2478866 2478866 plaintiff Fornfeld John   763746 763746 Fornfeld, John, of Thirnyng 0
5428343 2483402 2483402 plaintiff Fornfeld John   763746 763746 Fornfeld, John, of Thirnyng 0
5428347 2483403 2483403 plaintiff Fornfeld John   763746 763746 Fornfeld, John, of Thirnyng 0
5504043 2506181 2506181 defendant Redale Nicholas husbandman 763746 763746 Redale, Nicholas, of Thirnyng, husbandman 1
5551949 2520613 2520613 defendant Bulwer Thomas husbandman 763746 763746 Bulwer, Thomas, of Thirnyng, 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);