names

48 rows where place_id = 603892

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656120 1912168 1912168 defendant Broughton John husbandman 603892 603892 Broughton, John, of Greteham, husbandman 1
3718621 1932101 1932101 defendant Chace John husbandman 603892 603892 Chace, John, of Greteham, husbandman 1
3795815 1956558 1956558 defendant Mille William gent 603892 603892 Mille, William, of Greteham, gent 0
3795819 1956560 1956560 defendant Mylle William gent 603892 603892 Mylle, William, of Greteham, gent 0
3802260 1958602 1958602 defendant Apsley William gent 603892 603892 Apsley, William, of Greteham, gent 0
3808574 1960559 1960559 defendant Pratt William husbandman 603892 603892 Pratt, William, of Greteham, husbandman 0
4597812 2230570 2230570 defendant Hopkynson Henry (legal representative) 603892 603892 Hopkynson, Henry, of Greteham, executors of 0
4597813 2230570 2230570 defendant Hopkynson William   603892 603892 (Hopkynson, William, of Greteham 1
4728231 2274074 2274074 plaintiff Huntman John clerk & master 603892 603892 Huntman, John, of Greteham, clerk & master 0
4852759 2312283 2312283 defendant Storour Andrew husbandman 603892 603892 Storour, Andrew, of Greteham, husbandman 1
5042776 2369446 2369446 defendant Plumpton William gent 603892 603892 Plumpton, William, of Greteham, gent 0
5071212 2377887 2377887 defendant Chawmberlayne Walrer merchant 603892 603892 Chawmberlayne, Walrer, of Greteham, merchant 1
5142142 2398822 2398822 defendant Chafe William husbandman 603892 603892 Chafe, William, of Greteham, husbandman 0
5147190 2400317 2400317 defendant Stallok John   603892 603892 Stallok, John, of Greteham, cartwright 1
5147191 2400317 2400317 defendant Echard William husbandman 603892 603892 Echard, William, of Greteham, husbandman 2
5166977 2406074 2406074 defendant Stallok John   603892 603892 Stallok, John, of Greteham, cart wright 1
5166978 2406074 2406074 defendant Echard William husbandman 603892 603892 Echard, William, of Greteham, husbandman 2
5182178 2410540 2410540 defendant Stallok John   603892 603892 Stallok, John, of Greteham, cart wright 1
5182179 2410540 2410540 defendant Echard William husbandman 603892 603892 Echard, William, of Greteham, husbandman 2
5238702 2426916 2426916 defendant Fenn William husbandman 603892 603892 Fenn, William, of Greteham, husbandman 1
5306624 2446970 2446970 defendant Frankelayn William husbandman 603892 603892 Frankelayn, William, of Greteham, husbandman 1
5352413 2460856 2460856 defendant Chace William husbandman 603892 603892 Chace, William, of Greteham, husbandman 0
5457454 2492128 2492128 defendant Plompton John husbandman 603892 603892 Plompton, John, of Greteham, husbandman 0
5468264 2495447 2495447 defendant Chace Thomas husbandman 603892 603892 Chace, Thomas, of Greteham, husbandman 0
5490953 2502198 2502198 defendant Plomton John husbandman 603892 603892 Plomton, John, of Greteham, husbandman 0
5490954 2502198 2502198 defendant Man Thomas husbandman 603892 603892 Man, Thomas, of Greteham, husbandman 1
5490955 2502198 2502198 defendant Edmond William husbandman 603892 603892 Edmond, William, of Greteham, husbandman 2
5490956 2502198 2502198 defendant Leche William husbandman 603892 603892 Leche, William, of Greteham, husbandman 3
5490957 2502198 2502198 defendant Lydster William husbandman 603892 603892 Lydster, William, of Greteham, husbandman 4
5490958 2502198 2502198 defendant Hopkyns Robert husbandman 603892 603892 Hopkyns, Robert, of Greteham, husbandman 5
5490959 2502198 2502198 defendant Walker Henry husbandman 603892 603892 Walker, Henry, of Greteham, husbandman 6
5490960 2502198 2502198 defendant Acros John husbandman 603892 603892 Acros, John, of Greteham, husbandman 7
5490961 2502198 2502198 defendant Money John husbandman 603892 603892 Money, John, of Greteham, husbandman 8
5490962 2502198 2502198 defendant Welles Thomas husbandman 603892 603892 Welles, Thomas, of Greteham, husbandman 9
5490963 2502198 2502198 defendant Stalok John husbandman 603892 603892 Stalok, John, of Greteham, husbandman 10
5490964 2502198 2502198 defendant Torrey Robert husbandman 603892 603892 Torrey, Robert, of Greteham, husbandman 11
5490965 2502198 2502198 defendant Pykwell John husbandman 603892 603892 Pykwell, John, of Greteham, husbandman 12
5502912 2505823 2505823 defendant Rede Henry yeoman 603892 603892 Rede, Henry, of Greteham, yeoman 1
5526960 2513000 2513000 defendant Rede Nicholas yeoman 603892 603892 Rede, Nicholas, of Greteham, yeoman 0
5526962 2513001 2513001 defendant Rede Nicholas yeoman 603892 603892 Rede, Nicholas, of Greteham, yeoman 0
5526967 2513002 2513002 defendant Lussher Richard laborer 603892 603892 Lussher, Richard, of Greteham, laborer 3
5529722 2513802 2513802 defendant Lussher Richard laborer 603892 603892 Lussher, Richard, of Greteham, laborer 3
5529727 2513803 2513803 defendant Lussher Richard laborer 603892 603892 Lussher, Richard, of Greteham, laborer 3
5536618 2515940 2515940 defendant Chace John husbandman 603892 603892 Chace, John, of Greteham, husbandman 0
5536626 2515941 2515941 defendant Chace John husbandman 603892 603892 Chace, John, of Greteham, husbandman 4
5536627 2515941 2515941 defendant Cobbe John yeoman 603892 603892 Cobbe, John, of Greteham, yeoman 5
5536628 2515941 2515941 defendant Rede Nicholas yeoman 603892 603892 Rede, Nicholas, of Greteham, yeoman 6
5536629 2515941 2515941 defendant Carpynter John yeoman 603892 603892 Carpynter, John, of Greteham, yeoman 7

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