names

49 rows where place_id = 600292

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590861 1864772 1864772 defendant Fysshe Henry   600292 600292 Fysshe, Henry, of Tong, wright 0
3640477 1907453 1907453 defendant Waden William husbandman 600292 600292 Waden, William, of Tong, husbandman 4
3640483 1907454 1907454 defendant Waden William husbandman 600292 600292 Waden, William, of Tong, husbandman 4
3743364 1939798 1939798 defendant Abraham James husbandman 600292 600292 Abraham, James, of Tong, husbandman 1
3746502 1940818 1940818 defendant Starky Thomas gent 600292 600292 Starky, Thomas, of Tong, gent 0
3746503 1940818 1940818 defendant Starky Robert gent 600292 600292 Starky, Robert, of Tong, gent 1
3746504 1940818 1940818 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3746781 1940912 1940912 plaintiff Cripps John (legal representative) 600292 600292 Cripps, John, of Tong, executor of 0
3759849 1945074 1945074 defendant Starky Thomas gent 600292 600292 Starky, Thomas, of Tong, gent 0
3759850 1945074 1945074 defendant Starky Robert gent 600292 600292 Starky, Robert, of Tong, gent 1
3759851 1945074 1945074 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3759866 1945075 1945075 defendant Sterky Thomas gent 600292 600292 Sterky, Thomas, of Tong, gent 0
3759867 1945075 1945075 defendant Sterky Robert gent 600292 600292 Sterky, Robert, of Tong, gent 1
3759868 1945075 1945075 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3759869 1945075 1945075 defendant Dycton George laborer 600292 600292 Dycton, George, of Tong, laborer 3
3760310 1945228 1945228 plaintiff Cryppys John (legal representative) 600292 600292 Cryppys, John,of Tong, executor of 0
3767936 1947608 1947608 defendant Wildeblud William butcher 600292 600292 Wildeblud, William, of Tong, butcher 2
3767940 1947609 1947609 defendant Wyldebludde William butcher 600292 600292 Wyldebludde, William, of Tong, butcher 2
3778269 1950915 1950915 defendant Grynsted John husbandman 600292 600292 Grynsted, John, of Tong, husbandman 0
3778413 1950964 1950964 plaintiff Cryps John (legal representative) 600292 600292 Cryps, John, of Tong, executor of 0
3796947 1956926 1956926 defendant Milward Robert husbandman 600292 600292 Milward, Robert, of Tong, husbandman 0
3819445 1963966 1963966 defendant Cryppys Walter husbandman 600292 600292 Cryppys, Walter, of Tong, husbandman 0
3849947 1973571 1973571 defendant Cryppeys Walter husbandman 600292 600292 Cryppeys, Walter, of Tong, husbandman 0
3850404 1973715 1973715 defendant Mirfeld Christopher esq 600292 600292 Mirfeld, Christopher, of Tong, esq, son of Mirfeld, Peter, of Tong, esq 0
3868233 1979610 1979610 defendant Shererd John husbandman 600292 600292 Shererd, John, of Tong, husbandman 0
3879296 1983327 1983327 defendant Crofte John husbandman 600292 600292 Crofte, John, of Tong, husbandman 0
3879297 1983327 1983327 defendant Vycars William husbandman 600292 600292 Vycars, William, of Tong, husbandman 1
3879298 1983327 1983327 defendant Goldburgh John husbandman 600292 600292 Goldburgh, John, of Tong, husbandman 2
3879299 1983327 1983327 defendant Goldburgh Thomas husbandman 600292 600292 Goldburgh, Thomas, of Tong, husbandman 3
3888458 1986402 1986402 defendant Mirfeld Peter esq 600292 600292 Mirfeld, Peter, of Tong, esq 1
3987246 2020184 2020184 plaintiff Wylkyns Salmon gent 600292 600292 Wylkyns, Salmon, of Tong, gent 0
4259840 2116263 2116263 defendant Wylkyns David gent 600292 600292 Wylkyns, David, of Tong, gent 1
4731151 2274943 2274943 defendant Batman Richard   600292 600292 Batman, Richard, of Tong, smythe man 0
5057606 2373843 2373843 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5080827 2380756 2380756 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5105729 2388126 2388126 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5128668 2394869 2394869 defendant Appulderfeld Thomas   600292 600292 Appulderfeld, Thomas, of Tong 0
5147853 2400515 2400515 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5167368 2406192 2406192 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5203610 2416810 2416810 defendant Appulderfeld Thomas gent 600292 600292 Appulderfeld, Thomas, of Tong, gent 0
5373609 2467344 2467344 plaintiff Meryng Thomas esq 600292 600292 Meryng, Thomas, of Tong, esq 0
5390373 2472310 2472310 plaintiff Maryng Thomas esq 600292 600292 Maryng, Thomas, of Tong, esq 0
5403403 2476047 2476047 plaintiff Meryng Thomas esq 600292 600292 Meryng, Thomas, of Tong, esq 0
5416447 2479840 2479840 plaintiff Meryng Thomas esq 600292 600292 Meryng, Thomas, of Tong, esq 0
5416452 2479841 2479841 plaintiff Meryng Thomas esq 600292 600292 Meryng, Thomas, of Tong, esq 0
5536289 2515840 2515840 defendant Crepes John husbandman 600292 600292 Crepes, John, of Tong, husbandman 0
5537639 2516262 2516262 defendant Cryps John husbandman 600292 600292 Cryps, John, of Tong, husbandman 0
5559429 2522723 2522723 defendant Emery William husbandman 600292 600292 Emery, William, of Tong, husbandman 2
5594757 2533332 2533332 defendant Mirfeld Peter esq 600292 600292 Mirfeld, Peter, of Tong, esq 1

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