names

56 rows where place_id = 589912

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599235 1867402 1867402 defendant Fyssher Richard husbandman 589912 589912 Fyssher, Richard, of Leveryngton, Cams, husbandman 0
3599237 1867403 1867403 defendant Fyssher Richard husbandman 589912 589912 Fyssher, Richard, of Leveryngton, Cams, husbandman 0
3601914 1868254 1868254 defendant Plomme John yeoman 589912 589912 Plomme, John, of Leveryngton, Cams, yeoman 1
3606599 1869737 1869737 defendant Dyker John husbandman 589912 589912 Dyker, John, of Leveryngton, Cams, husbandman 1
3699689 1926127 1926127 defendant Adam Richard yeoman 589912 589912 Adam, Richard, of Leveryngton, Cams, yeoman 1
3707584 1928668 1928668 defendant Calowe Henry husbandman 589912 589912 Calowe, Henry, of Leveryngton, Cams, husbandman 0
3751622 1942423 1942423 defendant Drabbe John, senior (legal representative) 589912 589912 Drabbe, John, senior, of Leveryngton, Cams, husbandman, executor of 0
3758724 1944722 1944722 defendant Calowe Henry husbandman 589912 589912 Calowe, Henry, of Leveryngton, Cams, husbandman 2
3767993 1947626 1947626 defendant Drabbe John, senior (legal representative) 589912 589912 Drabbe, John, senior, of Leveryngton, Cams, husbandman, executor of 0
3776824 1950492 1950492 defendant Calowe Henry husbandman 589912 589912 Calowe, Henry, of Leveryngton, Cams, husbandman 0
3776831 1950493 1950493 defendant Calowe Henry husbandman 589912 589912 Calowe, Henry, of Leveryngton, Cams, husbandman 0
3784222 1952853 1952853 defendant Calowe Henry husbandman 589912 589912 Calowe, Henry, of Leveryngton, Cams, husbandman 0
3799627 1957806 1957806 defendant Johnson Thomas husbandman 589912 589912 Johnson, Thomas, of Leveryngton, Cams, husbandman 0
3831416 1967712 1967712 defendant Edward Robert husbandman 589912 589912 Edward, Robert, of Leveryngton, Cams, husbandman 2
3870905 1980518 1980518 defendant Wright Thomas carpenter 589912 589912 Wright, Thomas, of Leveryngton, Cams, carpenter 0
3901711 1990796 1990796 defendant Guarde Robert gent 589912 589912 Guarde, Robert, of Leveryngton, Cams, gent 0
3920022 1997035 1997035 defendant Edwardys William, senior yeoman 589912 589912 Edwardys, William, senior, of Leveryngton, Cams, yeoman 1
3920024 1997036 1997036 defendant Harrys Richard husbandman 589912 589912 Harrys, Richard, of Leveryngton, Cams, husbandman 0
3920027 1997037 1997037 defendant Harward William husbandman 589912 589912 Harward, William, of Parson Drove, Leveryngton, Cams, husbandman 0
3920030 1997038 1997038 defendant Hawkyn Richard husbandman 589912 589912 Hawkyn, Richard, of Parson Drove, Leveryngton, Cams, husbandman 0
3920036 1997039 1997039 defendant Fyssher Thomas husbandman 589912 589912 Fyssher, Thomas, of Parson Drove, Leveryngton, Cams, husbandman 1
3920050 1997043 1997043 defendant South John husbandman 589912 589912 South, John, of Parson Drove, Leveryngton, Cams, husbandman 0
3920056 1997044 1997044 defendant Cok William husbandman 589912 589912 Cok, William, of Leveryngton, Cams, husbandman 1
3920058 1997045 1997045 defendant Vycarye John yeoman 589912 589912 Vycarye, John, of Parson Drove, Leveryngton, Cams, yeoman 0
3920500 1997206 1997206 defendant Hunt Richard husbandman 589912 589912 (Hunt, Richard, of Leveryngton, Cams, husbandman 1
3920520 1997212 1997212 defendant Hunt Richard husbandman 589912 589912 (Hunt, Richard, of Leveryngton, Cams, husbandman 1
4261286 2116741 2116741 defendant Dennyson Robert, senior yeoman 589912 589912 Dennyson, Robert, senior, of Leveryngton, Cams, yeoman 0
4650966 2246301 2246301 defendant Beche Thomas husbandman 589912 589912 Beche, Thomas, of Leveryngton, Cams, husbandman 0
4663804 2250163 2250163 defendant Wynnok Simon   589912 589912 Wynnok, Simon, of Leveryngton, Cams 0
4666593 2251031 2251031 defendant Williamesson Richard yeoman 589912 589912 Williamesson, Richard, of Leveryngton, Cams, yeoman 0
4666598 2251032 2251032 defendant Williamesson Richard yeoman 589912 589912 Williamesson, Richard, of Leveryngton, Cams, yeoman 0
4866737 2316561 2316561 defendant Marsshall John husbandman 589912 589912 Marsshall, John, of Leveryngton, Cams, husbandman 0
4884690 2322124 2322124 defendant Colvyle John gent 589912 589912 Colvyle, John, of Leveryngton, Cams, gent 0
4891171 2323974 2323974 defendant Colvyle John gent 589912 589912 Colvyle, John, of Leveryngton, Cams, gent 9
4900731 2326868 2326868 defendant Reynold Thomas husbandman 589912 589912 Reynold, Thomas, of Leveryngton, Cams, husbandman 0
4948402 2341481 2341481 defendant Everard William gent 589912 589912 Everard, William, of Leveryngton, Cams, gent 0
4950398 2342090 2342090 defendant Herryson John husbandman 589912 589912 Herryson, John, of Leveryngton, Cams, husbandman 3
4975807 2349730 2349730 defendant Bytam John yeoman 589912 589912 Bytam, John, of Leveryngton, Cams, yeoman 0
4977941 2350365 2350365 defendant Sporyour Robert husbandman 589912 589912 Sporyour, Robert, of Leveryngton, Cams, husbandman 0
4983377 2351935 2351935 defendant Reynold William husbandman 589912 589912 Reynold, William, of Leveryngton, Cams, husbandman 0
4983379 2351936 2351936 defendant Reynold William husbandman 589912 589912 Reynold, William, of Leveryngton, Cams, husbandman 0
5015710 2361480 2361480 defendant Edward Martin husbandman 589912 589912 Edward, Martin, of Leveryngton, Cams, husbandman 3
5023886 2363897 2363897 defendant Warner John husbandman 589912 589912 Warner, John, of Leveryngton, Cams, husbandman 2
5034612 2366983 2366983 defendant Edward Martin husbandman 589912 589912 Edward, Martin, of Leveryngton, Cams, husbandman 0
5068720 2377140 2377140 defendant Clerk Robert husbandman 589912 589912 Clerk, Robert, of Leveryngton, Cams, husbandman 0
5083226 2381481 2381481 defendant Dygby John husbandman 589912 589912 Dygby, John, of Leveryngton, Cams, husbandman 0
5107851 2388734 2388734 defendant Everard William gent 589912 589912 Everard, William, of Leveryngton, Cams, gent 0
5226766 2423495 2423495 defendant Edward Martin husbandman 589912 589912 Edward, Martin, of Leveryngton, Cams, husbandman 0
5231414 2424774 2424774 defendant Everard Hugh gent 589912 589912 Everard, Hugh, of Leveryngton, Cams, gent 1
5483702 2500076 2500076 defendant Pore Thomas husbandman 589912 589912 Pore, Thomas, of Leveryngton, Cams, husbandman 0
5483939 2500133 2500133 defendant Page Thomas husbandman 589912 589912 Page, Thomas, of Leveryngton, Cams, husbandman 5
5495400 2503526 2503526 defendant Plombe John husbandman 589912 589912 Plombe, John, of Leveryngton, Cams, husbandman 2
5580130 2528869 2528869 defendant Balam Alexander gent 589912 589912 (Balam, Alexander, of Leveryngton, Cams, gent 1
5623859 2551408 2551408 defendant Grey Elias laborer 589912 589912 Grey, Elias, of Leveryngton, Cams, laborer 0
5631413 2553827 2553827 defendant Thory Robert husbandman 589912 589912 Thory, Robert, of Leveryngton, Cams, husbandman 0
5633070 2554345 2554345 defendant Wynnok Simon laborer 589912 589912 Wynnok, Simon, of Leveryngton, Cams, laborer 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);