names

50 rows where place_id = 605127

✎ 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
3660498 1913546 1913546 defendant Bartelot John yeoman 605127 605127 Bartelot, John, of Heston, yeoman 0
3665285 1915095 1915095 defendant Lovebek Thomas husbandman 605127 605127 Lovebek, Thomas, of Heston, husbandman 0
3667640 1915822 1915822 defendant Clerk Thomas husbandman 605127 605127 Clerk, Thomas, of Heston, husbandman 4
3707474 1928630 1928630 defendant Chylde Richard yeoman 605127 605127 Chylde, Richard, of Heston, yeoman 2
3727307 1934815 1934815 defendant Bartlott John draper 605127 605127 Bartlott, John, of Heston, draper 4
3727312 1934817 1934817 defendant Bartlott John draper 605127 605127 Bartlott, John, of Heston, draper 1
3776962 1950539 1950539 defendant Hale John maltman 605127 605127 Hale, John, of Heston, maltman 0
4455278 2186663 2186663 defendant Bertelot John   605127 605127 Bertelot, John, of Heston 0
4647504 2245331 2245331 plaintiff Bacheler John   605127 605127 Bacheler, John, of Heston 4
4664915 2250506 2250506 defendant Lyvyng John husbandman 605127 605127 Lyvyng, John, of Heston, husbandman 1
4664916 2250506 2250506 defendant Palette John husbandman 605127 605127 Palette, John, of Heston, husbandman 2
4673406 2257320 2257320 defendant Curre William husbandman 605127 605127 Curre, William, of Heston, husbandman 1
4685708 2261119 2261119 defendant Page John yeoman 605127 605127 Page, John, of Heston, yeoman 0
4711646 2268968 2268968 defendant page John yeoman 605127 605127 page, John, of Heston, yeoman 1
4726353 2273526 2273526 defendant Best Roger husbandman 605127 605127 Best, Roger, of Heston, husbandman 1
4726356 2273527 2273527 defendant Best Roger husbandman 605127 605127 Best, Roger, of Heston, husbandman 1
4772344 2287315 2287315 defendant Palet John husbandman 605127 605127 Palet, John, of Heston, husbandman 0
4772348 2287316 2287316 defendant Palet John husbandman 605127 605127 Palet, John, of Heston, husbandman 0
5014834 2361214 2361214 defendant Martyn Thomas (legal representative) 605127 605127 Martyn, Thomas, of Heston, executors of 3
5014836 2361214 2361214 defendant Denby Henry husbandman 605127 605127 Denby, Henry, of Heston, husbandman 5
5047555 2370888 2370888 defendant Lawe Richard smith 605127 605127 Lawe, Richard, of Heston, smith 1
5047558 2370889 2370889 defendant Bawe Richard smith 605127 605127 Bawe, Richard, of Heston, smith 1
5092989 2384339 2384339 defendant Budbroke William husbandman 605127 605127 Budbroke, William, of Heston, husbandman 0
5112784 2390132 2390132 defendant Spencer John carpenter 605127 605127 Spencer, John, of Heston, carpenter 0
5112786 2390133 2390133 defendant Spencer John carpenter 605127 605127 Spencer, John, of Heston, carpenter 0
5193239 2413753 2413753 defendant Curre John butcher 605127 605127 Curre, John, of Heston, butcher 0
5206726 2417704 2417704 defendant Spenser John carpenter 605127 605127 Spenser, John, of Heston, carpenter 1
5208088 2418097 2418097 defendant Curre John butcher 605127 605127 Curre, John, of Heston, butcher 0
5208090 2418098 2418098 defendant Curro John butcher 605127 605127 Curro, John, of Heston, butcher 0
5222878 2422405 2422405 defendant Curre John husbandman 605127 605127 Curre, John, of Heston, husbandman 2
5222879 2422405 2422405 defendant Acastyr John husbandman 605127 605127 Acastyr, John, of Heston, husbandman 3
5226835 2423513 2423513 defendant Curre John butcher 605127 605127 Curre, John, of Heston, butcher 3
5261935 2433840 2433840 defendant Jurden Richard husbandman 605127 605127 Jurden, Richard, of Heston, husbandman 3
5277671 2438553 2438553 defendant Forde Thomas husbandman 605127 605127 Forde, Thomas, of Heston, husbandman 2
5300667 2445162 2445162 defendant Whityng Walter weaver 605127 605127 Whityng, Walter, of Heston, weaver 0
5300669 2445163 2445163 defendant Whytyng Walter weaver 605127 605127 Whytyng, Walter, of Heston, weaver 0
5332648 2454832 2454832 defendant Werysale William husbandman 605127 605127 Werysale, William, of Heston, husbandman 1
5339966 2457070 2457070 defendant Jurdan Richard husbandman 605127 605127 Jurdan, Richard, of Heston, husbandman 2
5339967 2457070 2457070 defendant Budbroke William husbandman 605127 605127 Budbroke, William, of Heston, husbandman 3
5374589 2467658 2467658 defendant Abry John husbandman 605127 605127 Abry, John, of Heston, husbandman 1
5416847 2479959 2479959 defendant Harper Henry   605127 605127 Harper, Henry, of Heston 0
5523074 2512042 2512042 defendant Alyn Walter husbandman 605127 605127 Alyn, Walter, of Heston, husbandman 0
5526656 2512904 2512904 defendant Harrys John husbandman 605127 605127 Harrys, John, of Heston St Peter, husbandman 0
5546938 2519104 2519104 defendant Bartilmewe William butcher 605127 605127 Bartilmewe, William, of Heston, butcher 0
5546939 2519104 2519104 defendant Chylde Richard butcher 605127 605127 Chylde, Richard, of Heston, butcher 1
5571848 2526307 2526307 defendant Marlowe alias Luffenam John yeoman 605127 605127 Marlowe alias Luffenam, John, of Heston, yeoman 0
5582894 2529716 2529716 defendant Lyneard John husbandman 605127 605127 Lyneard, John, of Heston, husbandman 1
5636115 2555251 2555251 defendant James Richard butcher 605127 605127 James, Richard, of Heston, butcher 0
5636116 2555251 2555251 defendant Curre William ploughman 605127 605127 Curre, William, of Heston, ploughman 1
5636117 2555251 2555251 defendant Bartilot John laborer 605127 605127 Bartilot, John, of Heston, laborer 2

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