names

57 rows where place_id = 597996

✎ 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
3630699 1904430 1904430 defendant Alesson John clerk 597996 597996 Alesson, John, of Roxston, clerk 0
3630930 1904493 1904493 defendant Chyld Thomas husbandman 597996 597996 Chyld, Thomas, of Roxston, husbandman 3
3630934 1904494 1904494 defendant Peter John laborer 597996 597996 Peter, John, of Roxston, laborer 2
3632335 1904934 1904934 defendant Child Thomas, senior husbandman 597996 597996 Child, Thomas, senior, of Roxston, husbandman 0
3638447 1906847 1906847 defendant Fraunces Thomas husbandman 597996 597996 Fraunces, Thomas, of Roxston, husbandman 2
3638448 1906847 1906847 defendant Chylde Richard husbandman 597996 597996 Chylde, Richard, of Roxston, husbandman 3
3657509 1912609 1912609 defendant Stoughton Thomas husbandman 597996 597996 Stoughton, Thomas, of Roxston, husbandman 0
3657511 1912609 1912609 defendant Lumbard John husbandman 597996 597996 Lumbard, John, of Roxston, husbandman 2
3689747 1922950 1922950 defendant Chylde William husbandman 597996 597996 Chylde, William, of Roxston, husbandman 1
3689748 1922950 1922950 defendant Chylde Thomas husbandman 597996 597996 Chylde, Thomas, of Roxston, husbandman 2
3723350 1933571 1933571 defendant Merser Margaret widow 597996 597996 Merser, Margaret, of Roxston, widow 5
3876455 1982372 1982372 defendant Jonys Humphrey yeoman 597996 597996 Jonys, Humphrey, of Roxston, yeoman 0
3876456 1982372 1982372 defendant Gybbons Walter yeoman 597996 597996 Gybbons, Walter, of Roxston, yeoman 1
4127619 2070169 2070169 defendant Pope Jane widow 597996 597996 Pope, Jane, of Roxston, widow 1
4135927 2073182 2073182 defendant Pope John (legal representative) 597996 597996 Pope, John, of Roxston, esq, administratrix of 0
4135928 2073182 2073182 defendant Pope Jane widow 597996 597996 Pope, Jane, of Roxston, widow 1
4401103 2164963 2164963 defendant Bearde alias Farmer William yeoman 597996 597996 Bearde alias Farmer, William, of Roxston, yeoman 0
4456560 2187075 2187075 defendant Warde John   597996 597996 Warde, John, of Roxston 0
4572746 2223015 2223015 defendant Bocher Robert   597996 597996 Bocher, Robert, of Roxston 3
4732375 2275304 2275304 defendant Danby John husbandman 597996 597996 Danby, John, of Roxston, husbandman 1
4758250 2282955 2282955 defendant Peddere Thomas   597996 597996 Peddere, Thomas, of Roxston, mill ward 0
4809969 2299278 2299278 defendant Danby John tailor 597996 597996 Danby, John, of Roxston, tailor 0
4810060 2299301 2299301 defendant Cook John   597996 597996 Cook, John, of Roxston, cook 0
4810061 2299301 2299301 defendant Frank John ploughman 597996 597996 Frank, John, of Roxston, ploughman 1
4810062 2299301 2299301 defendant Reve John laborer 597996 597996 Reve, John, of Roxston, laborer 2
4868653 2317169 2317169 defendant Pedder Thomas miller 597996 597996 Pedder, Thomas, of Roxston, miller 0
4882726 2321515 2321515 defendant Pedder Thomas miller 597996 597996 Pedder, Thomas, of Roxston, miller 0
4894940 2325079 2325079 defendant Pedder Thomas miller 597996 597996 Pedder, Thomas, of Roxston, miller 0
4925334 2334355 2334355 defendant Childe Henry husbandman 597996 597996 Childe, Henry, of Roxston, husbandman 1
4962183 2345592 2345592 defendant Cukko Hugh husbandman 597996 597996 Cukko, Hugh, of Roxston, husbandman 4
5057720 2373877 2373877 defendant Huet John husbandman 597996 597996 Huet, John, of Roxston, husbandman 0
5071828 2378069 2378069 defendant Cukkowe Hugh tailor 597996 597996 Cukkowe, Hugh, of Roxston, tailor 0
5083511 2381570 2381570 defendant Cukkowe Hugh husbanman 597996 597996 Cukkowe, Hugh, of Roxston, husbanman 0
5100234 2386510 2386510 defendant Byrtvyle William gent 597996 597996 Byrtvyle, William, of Roxston, gent 0
5221232 2421907 2421907 defendant Kockowe Hugh husbandman 597996 597996 Kockowe, Hugh, of Roxston, husbandman 1
5279071 2438986 2438986 defendant Richard Thomas husbandman 597996 597996 Richard, Thomas, of Roxston, husbandman 2
5279075 2438987 2438987 defendant Richard Thomas husbandman 597996 597996 Richard, Thomas, of Roxston, husbandman 2
5289982 2442074 2442074 defendant Wokam Richard hosteler 597996 597996 Wokam, Richard, of Roxston, hosteler 0
5373360 2467270 2467270 plaintiff Massy Hamo   597996 597996 Massy, Hamo, of Roxston 0
5379979 2469324 2469324 defendant Myton Robert yeoman 597996 597996 Myton, Robert, of Roxston, yeoman 0
5425224 2482515 2482515 defendant Chylde Richard husbandman 597996 597996 Chylde, Richard, of Roxston, husbandman 0
5456479 2491862 2491862 defendant Childe Richard husbandman 597996 597996 Childe, Richard, of Roxston, husbandman 0
5456483 2491863 2491863 defendant Childe William husbandman 597996 597996 Childe, William, of Roxston, husbandman 1
5470023 2495952 2495952 defendant Childe Richard maltman 597996 597996 Childe, Richard, of Roxston, maltman 2
5470024 2495952 2495952 defendant Childe William maltman 597996 597996 Childe, William, of Roxston, maltman 3
5493151 2502861 2502861 defendant Myton Robert husbandman 597996 597996 Myton, Robert, of Roxston, husbandman 0
5493154 2502861 2502861 defendant Chylde Thomas husbandman 597996 597996 Chylde, Thomas, of Roxston, husbandman 3
5511123 2508319 2508319 defendant Frankleyn William yeoman 597996 597996 Frankleyn, William, of Roxston, yeoman 0
5543650 2518122 2518122 defendant Chylde Richard husbandman 597996 597996 Chylde, Richard, of Roxston, husbandman 0
5543652 2518122 2518122 defendant Harryson William husbandman 597996 597996 Harryson, William, of Roxston, husbandman 2
5563066 2523794 2523794 defendant Fraunceys Thomas husbandman 597996 597996 Fraunceys, Thomas, of Roxston, husbandman 3
5568393 2525302 2525302 defendant Chyld Thomas yeoman 597996 597996 Chyld, Thomas, of Roxston, yeoman 2
5568394 2525302 2525302 defendant Lombard Hugh husbandman 597996 597996 Lombard, Hugh, of Roxston, husbandman 3
5568396 2525303 2525303 defendant Tynggey Richard husbandman 597996 597996 Tynggey, Richard, of Roxston, husbandman 0
5568397 2525303 2525303 defendant Berd Thomas husbandman 597996 597996 Berd, Thomas, of Roxston, husbandman 1
5568398 2525303 2525303 defendant Coryer Thmoas yeoman 597996 597996 Coryer, Thmoas, of Roxston, yeoman 2
5568399 2525303 2525303 defendant Chyld William yeoman 597996 597996 Chyld, William, of Roxston, yeoman 3

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