names

38 rows where place_id = 599732

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3638033 1906714 1906714 defendant Richard William, senior husbandman 599732 599732 Richard, William, senior, of Sydenham, husbandman 0
3638034 1906714 1906714 defendant Richard William, junior husbandman 599732 599732 Richard, William, junior, of Sydenham, husbandman 1
3638035 1906714 1906714 defendant Cornysshe John husbandman 599732 599732 Cornysshe, John, of Sydenham, husbandman 2
3644764 1908767 1908767 defendant Strowte Edward husbandman 599732 599732 Strowte, Edward, of Sydenham, husbandman 0
3654269 1911594 1911594 defendant Neyburgh John husbandman 599732 599732 Neyburgh, John, of Sydenham, husbandman 2
3751420 1942360 1942360 defendant Hasylwode William   599732 599732 Hasylwode, William, of Sydenham, cook 0
3788127 1954081 1954081 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3845736 1972214 1972214 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3849346 1973393 1973393 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3856894 1975787 1975787 defendant Wyse John gent 599732 599732 Wyse, John, of Sydenham, gent 0
3861488 1977303 1977303 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3865102 1978532 1978532 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3879172 1983287 1983287 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
3879178 1983289 1983289 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
4466297 2190119 2190119 defendant Michel John   599732 599732 Michel, John, of Sydenham 0
4488220 2197031 2197031 defendant Sydenham John   599732 599732 Sydenham, John, of Sydenham 0
4493780 2198747 2198747 defendant Sydenham John   599732 599732 Sydenham, John, of Sydenham 0
4519569 2206483 2206483 defendant Michel John   599732 599732 Michel, John, of Sydenham 0
4519570 2206483 2206483 defendant Mi_ Henry   599732 599732 Mi_, Henry, of Sydenham 1
4532194 2210334 2210334 defendant Jurdan William   599732 599732 Jurdan, William, of Sydenham 0
4601658 2231736 2231736 defendant Crowell William   599732 599732 Crowell, William, of Sydenham 4
4724475 2272949 2272949 defendant Wyse John esq 599732 599732 Wyse, John, of Sydenham, esq 0
4817292 2301500 2301500 defendant Hamelden William husbandman 599732 599732 Hamelden, William, of Sydenham, husbandman 0
4828563 2304973 2304973 defendant Wyse Thomas esq 599732 599732 Wyse, Thomas, of Sydenham, esq 0
4843938 2309621 2309621 defendant Hamelden William husbandman 599732 599732 Hamelden, William, of Sydenham, husbandman 0
4892403 2324364 2324364 defendant Peuesey or Penesey William laborer 599732 599732 Peuesey or Penesey, William, of Sydenham, laborer 0
4896449 2325557 2325557 defendant Hamulden William husbandman 599732 599732 Hamulden, William, of Sydenham, husbandman 1
5019781 2362665 2362665 defendant Wyse Thomas esq 599732 599732 Wyse, Thomas, of Sydenham, esq 0
5046329 2370537 2370537 defendant Wyse Thomas esq 599732 599732 Wyse, Thomas, of Sydenham, esq 0
5085210 2382075 2382075 defendant Eustace William husbandman 599732 599732 Eustace, William, of Sydenham, husbandman 1
5114290 2390574 2390574 defendant Richard William tucker 599732 599732 Richard, William, of Sydenham, tucker 0
5183014 2410778 2410778 defendant Heys Thomas husbandman 599732 599732 Heys, Thomas, of Sydenham in Bryggewater, husbandman 0
5203673 2416827 2416827 defendant Heys Thomas husbandman 599732 599732 Heys, Thomas, of Sydenham in Bryggewater, husbandman 0
5272988 2437172 2437172 defendant Bowyer Thomas mercer 599732 599732 Bowyer, Thomas, of Sydenham, mercer 0
5398911 2474756 2474756 defendant Philpot Nicholas husbandman 599732 599732 Philpot, Nicholas, of Sydenham, husbandman 0
5564461 2524225 2524225 defendant Hester Robert husbandman 599732 599732 Hester, Robert, of Sydenham, husbandman 0
5598245 2534341 2534341 defendant Hester Robert husbandman 599732 599732 Hester, Robert, of Sydenham, husbandman 0
5633448 2554457 2554457 defendant Hamelden William husbandman 599732 599732 Hamelden, William, of Sydenham, husbandman 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);