names

43 rows where place_id = 645542

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591415 1864941 1864941 defendant Agate Ralph   645542 645542 Agate, Ralph, of New Shorham, fish hook maker 0
3886111 1985604 1985604 defendant Marten John husbandman 645542 645542 Marten, John, of New Shorham, husbandman 0
3892140 1987625 1987625 defendant Pawlett John fisherman 645542 645542 Pawlett, John, of New Shorham, fisherman 0
3895502 1988701 1988701 defendant Dobbyng Edward fisherman 645542 645542 Dobbyng, Edward, of New Shorham, fisherman 4
3913826 1994971 1994971 defendant Bredon John husbandman 645542 645542 Bredon, John, of New Shorham, husbandman 0
4058918 2045584 2045584 defendant Gravesende Richard yeoman 645542 645542 Gravesende, Richard, of New Shorham, yeoman 0
4080449 2053318 2053318 defendant Gravesend Richard yeoman 645542 645542 Gravesend, Richard, of New Shorham, yeoman 0
4127783 2070226 2070226 defendant Clyffe Thomas merchant 645542 645542 Clyffe, Thomas, of New Shorham, merchant 0
4127784 2070226 2070226 defendant Harman Richard merchant 645542 645542 Harman, Richard, of New Shorham, merchant 1
4167124 2084007 2084007 defendant Hester John brewer 645542 645542 Hester, John, of New Shorham, brewer 1
4167188 2084027 2084027 defendant Erle Richard gent 645542 645542 Erle, Richard, of New Shorham, gent 2
4182938 2089512 2089512 defendant Gravesend Richard yeoman 645542 645542 Gravesend, Richard, of New Shorham, yeoman 0
4182939 2089512 2089512 defendant Phyllyppes Edward merchant 645542 645542 Phyllyppes, Edward, of New Shorham, merchant 1
4182940 2089512 2089512 defendant Cager Roger fisherman 645542 645542 Cager, Roger, of New Shorham, fisherman 2
4413007 2168943 2168943 plaintiff Apselond Adam   645542 645542 Apselond, Adam, of New Shorham 0
4414572 2169463 2169463 plaintiff Dyseland Adam   645542 645542 Dyseland, Adam, of New Shorham 0
4414575 2169463 2169463 defendant Perchynge Ralph   645542 645542 Perchynge, Ralph, of New Shorham 2
4428657 2173765 2173765 plaintiff Swele John   645542 645542 Swele, John, of New Shorham 0
4444792 2183345 2183345 plaintiff Cony William (legal representative) 645542 645542 Cony, William, of New Shorham, executors of 0
4444795 2183345 2183345 plaintiff Avenell John   645542 645542 Avenell, John, of New Shorham, vicar 3
4454389 2186384 2186384 plaintiff Fermour Richard   645542 645542 Fermour, Richard, of New Shorham 2
4468729 2190894 2190894 plaintiff Borlee Walter   645542 645542 Borlee, Walter, of New Shorham 1
4670704 2256517 2256517 defendant Kendale John husbandman 645542 645542 Kendale, John, of New Shorham, husbandman 2
4743691 2278684 2278684 defendant Roger Richard husbandman 645542 645542 Roger, Richard, of New Shorham, husbandman 0
4809662 2299186 2299186 defendant atte Hese William husbandman 645542 645542 atte Hese, William, of New Shorham, husbandman 0
4857293 2313669 2313669 defendant Luns John shipman 645542 645542 Luns, John, of New Shorham, shipman 0
4861894 2315097 2315097 defendant Pyndere John laborer 645542 645542 Pyndere, John, of New Shorham, laborer 0
4881538 2321128 2321128 plaintiff Wryther John   645542 645542 Wryther, John, of New Shorham 0
4894489 2324948 2324948 plaintiff Dammere Richard   645542 645542 Dammere, Richard, of New Shorham 0
4904570 2328040 2328040 defendant Furby John yeoman 645542 645542 Furby, John, of New Shorham, yeoman 1
4917816 2332085 2332085 defendant Sprot Robert shipman 645542 645542 Sprot, Robert, of New Shorham, shipman 0
4917817 2332085 2332085 defendant Foxe Walter shoemaker 645542 645542 Foxe, Walter, of New Shorham, shoemaker 1
4947087 2341082 2341082 defendant Bocher Thomas butcher 645542 645542 Bocher, Thomas, of New Shorham, butcher 2
4991253 2354267 2354267 defendant Snellyng William smith 645542 645542 Snellyng, William, of New Shorham, smith 1
5112346 2389998 2389998 defendant Goddysmarke John carpenter 645542 645542 Goddysmarke, John, of New Shorham, carpenter 1
5248004 2429551 2429551 defendant Stempe Richard baker 645542 645542 Stempe, Richard, of New Shorham, baker 0
5248005 2429551 2429551 defendant Stempe Isabel widow 645542 645542 Stempe, Isabel, of New Shorham, widow 1
5414929 2479398 2479398 defendant Eston John husbandman 645542 645542 Eston, John, of New Shorham, husbandman 3
5486680 2500915 2500915 defendant Agate Robert   645542 645542 Agate, Robert, of New Shorham, hook maker 0
5522130 2511735 2511735 defendant Okeburn Roger weaver 645542 645542 Okeburn, Roger, of New Shorham, weaver 0
5583306 2529850 2529850 defendant Dubbyng John husbandman 645542 645542 Dubbyng, John, of New Shorham, husbandman 1
5634426 2554763 2554763 defendant Purcas Thomas   645542 645542 Purcas, Thomas, of New Shorham 0
5634428 2554764 2554764 defendant Purcas Thomas   645542 645542 Purcas, Thomas, of New Shorham 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);