names

52 rows where place_id = 633917

✎ 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
3746441 1940807 1940807 plaintiff Colyer Robert (legal representative) 633917 633917 Colyer, Robert, of Dorlaston, yeoman, executors of 0
3777642 1950757 1950757 plaintiff Colyer Robert (legal representative) 633917 633917 Colyer, Robert, of Dorlaston, yeoman, executors of 0
3815605 1962796 1962796 defendant Hole Henry smith 633917 633917 Hole, Henry, of Dorlaston, smith 0
3831286 1967670 1967670 defendant Preston John husbandman 633917 633917 Preston, John, of Dorlaston, husbandman 0
3831287 1967670 1967670 defendant Blakemore Richard husbandman 633917 633917 Blakemore, Richard, of Dorlaston, husbandman 1
3831966 1967895 1967895 defendant Mullynars John collier 633917 633917 Mullynars, John, of Dorlaston, collier 3
3867261 1979286 1979286 defendant Robynson Thomas husbandman 633917 633917 Robynson, Thomas, of Dorlaston, husbandman 0
3868785 1979801 1979801 defendant Haye Edward husbandman 633917 633917 Haye, Edward, of Dorlaston, husbandman 0
3871228 1980630 1980630 defendant Flynte Stephen husbandman 633917 633917 Flynte, Stephen, of Dorlaston, husbandman 1
3882591 1984441 1984441 defendant Haye Edward husbandman 633917 633917 Haye, Edward, of Dorlaston, husbandman 0
3884865 1985208 1985208 defendant Taylour William husbandman 633917 633917 Taylour, William, of Dorlaston, husbandman 1
3975123 2015862 2015862 defendant Baylye Roger yeoman 633917 633917 Baylye, Roger, of Dorlaston, yeoman 0
3987069 2020117 2020117 defendant Baylye Roger yeoman 633917 633917 Baylye, Roger, of Dorlaston, yeoman 0
3994455 2022770 2022770 defendant Collyer Robert esq 633917 633917 Collyer, Robert, of Dorlaston, esq 2
4004603 2026420 2026420 defendant Baylye Roger yeoman 633917 633917 Baylye, Roger, of Dorlaston, yeoman 0
4019167 2031592 2031592 defendant Colliar Robert esq 633917 633917 Colliar, Robert, of Dorlaston, esq 0
4069793 2049485 2049485 defendant Fabell Henry yeoman 633917 633917 Fabell, Henry, of Dorlaston, yeoman 0
4069812 2049488 2049488 defendant Carter John yeoman 633917 633917 Carter, John, of Dorlaston, yeoman 1
4098963 2059953 2059953 defendant Meare Thomas husbandman 633917 633917 Meare, Thomas, of Dorlaston, husbandman 1
4137206 2073654 2073654 defendant Clarke Edward collier 633917 633917 Clarke, Edward, of Dorlaston, collier 0
4147885 2077396 2077396 defendant Parker Joan widow 633917 633917 Parker, Joan, of Dorlaston, widow 0
4147887 2077396 2077396 defendant Wynspere Nicholas tailor 633917 633917 Wynspere, Nicholas, of Dorlaston, tailor 2
4326353 2139179 2139179 defendant Forster Thomas   633917 633917 Forster, Thomas, of Dorlaston, buckle maker 0
4328441 2139827 2139827 defendant Porter Richard bucklemaker 633917 633917 Porter, Richard, of Dorlaston, bucklemaker 1
4340080 2143797 2143797 defendant Morrey Thomas yeoman 633917 633917 Morrey, Thomas, of Dorlaston, yeoman 1
4684627 2260791 2260791 plaintiff Pype Richard   633917 633917 Pype, Richard, of Dorlaston 0
4705940 2267235 2267235 defendant Longeley Nicholas husbandman 633917 633917 Longeley, Nicholas, of Dorlaston, husbandman 0
4722267 2272285 2272285 defendant Dorlaston Idonea   633917 633917 Dorlaston, Idonea, of Dorlaston, gentle woman, formerly wife of Robert 0
4729632 2274480 2274480 defendant Bate Thomas   633917 633917 Bate, Thomas, of Dorlaston, iron worker 0
4729633 2274480 2274480 defendant Tylemaker John   633917 633917 Tylemaker, John, of Dorlaston, tile maker 1
4772796 2287460 2287460 defendant Sommaystyr John clerk 633917 633917 Sommaystyr, John, of Dorlaston, clerk 0
4787992 2292311 2292311 plaintiff Harper Thomas   633917 633917 Harper, Thomas, of Dorlaston 0
4827338 2304598 2304598 defendant Hogettus John husbandman & son of John Hogettus 633917 633917 Hogettus, John, of Dorlaston, husbandman & son of John Hogettus 1
4929634 2335683 2335683 defendant Pert Roger carrier 633917 633917 Pert, Roger, of Dorlaston, carrier 0
4929635 2335683 2335683 defendant Pert John carrier 633917 633917 Pert, John, of Dorlaston, carrier 1
4952971 2342850 2342850 defendant Nytynghale Henry smith 633917 633917 Nytynghale, Henry, of Dorlaston, smith 0
5010667 2359988 2359988 defendant Nyghtynghale Henry ironmonger 633917 633917 Nyghtynghale, Henry, of Dorlaston, ironmonger 0
5010669 2359989 2359989 defendant Nyghytnghale Henry ironmonger 633917 633917 Nyghytnghale, Henry, of Dorlaston, ironmonger 0
5034930 2367074 2367074 defendant Mollesley Roger drover 633917 633917 Mollesley, Roger, of Dorlaston, drover 0
5070336 2377621 2377621 defendant Pert John yeoman 633917 633917 Pert, John, of Dorlaston, yeoman 2
5070337 2377621 2377621 defendant Mollesley Roger drover 633917 633917 Mollesley, Roger, of Dorlaston, drover 3
5080221 2380572 2380572 defendant Mollesley Roger husbandman 633917 633917 Mollesley, Roger, of Dorlaston, husbandman 1
5086325 2382392 2382392 defendant Kay Richard smith 633917 633917 Kay, Richard,of Dorlaston, smith 0
5128290 2394752 2394752 defendant Mollesley Roger husbandman 633917 633917 Mollesley, Roger, of Dorlaston, husbandman 0
5170057 2406978 2406978 defendant Haukys William   633917 633917 Haukys, William, of Dorlaston, smithy man 0
5295088 2443551 2443551 defendant Peert Richard husbandman 633917 633917 Peert, Richard, of Dorlaston, husbandman 0
5315336 2449643 2449643 plaintiff Cokkes William   633917 633917 Cokkes, William, of Dorlaston 0
5315338 2449644 2449644 plaintiff Cokkes William   633917 633917 Cokkes, William, of Dorlaston 0
5551268 2520403 2520403 defendant Waller Richard yeoman 633917 633917 Waller, Richard, of Dorlaston, yeoman 1
5554953 2521451 2521451 defendant Gere Thomas husbandman 633917 633917 Gere, Thomas, of Dorlaston, husbandman 1
5581676 2529352 2529352 defendant Gere Thomas yeoman 633917 633917 Gere, Thomas, of Dorlaston, yeoman 1
5581680 2529353 2529353 defendant Gere Thomas yeoman 633917 633917 Gere, Thomas, of Dorlaston, yeoman 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);