names

39 rows where place_id = 599105

✎ 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
3635261 1905817 1905817 defendant Arblaster Thomas gent 599105 599105 Arblaster, Thomas, of Tendryng, gent 0
3656793 1912379 1912379 defendant Yemys Simon yeoman 599105 599105 Yemys, Simon, of Tendryng, yeoman 1
3672214 1917309 1917309 defendant Roger John barber 599105 599105 Roger, John, of Tendryng, barber 2
3688236 1922471 1922471 defendant Roger John   599105 599105 Roger, John, of Tendryng, wax chandler 2
3835316 1968985 1968985 defendant Wade Thomas laborer 599105 599105 Wade, Thomas, of Tendryng, laborer 0
3835483 1969037 1969037 defendant Burnett Richard husbandman 599105 599105 Burnett, Richard, of Tendryng, husbandman 3
3880449 1983717 1983717 defendant Woderofe John husbandman 599105 599105 Woderofe, John, of Tendryng, husbandman 5
4032605 2036310 2036310 defendant Rose Richard blacksmith 599105 599105 Rose, Richard, of Tendryng, blacksmith 0
4078656 2052663 2052663 defendant Lyllye Thomas husbandman 599105 599105 Lyllye, Thomas, of Tendryng, husbandman 0
4424973 2172648 2172648 defendant Altheworld Henry   599105 599105 Altheworld, Henry, of Tendryng 6
4455065 2186587 2186587 defendant Smale Gilber   599105 599105 Smale, Gilber, of Tendryng 2
4472473 2192059 2192059 defendant Moys Walter   599105 599105 Moys, Walter, of Tendryng 0
4483297 2195476 2195476 plaintiff Norays Walter   599105 599105 Norays, Walter, of Tendryng, son of Eleanor 2
4660899 2249234 2249234 defendant Mynton William gent 599105 599105 Mynton, William, of Tendryng, gent 0
4660914 2249237 2249237 defendant Mynton William   599105 599105 Mynton, William, of Tendryng 8
4691237 2262778 2262778 defendant Molle John husbandman 599105 599105 Molle, John, of Tendryng, husbandman 0
4744134 2278811 2278811 defendant Barkere John husbandman 599105 599105 Barkere, John, of Tendryng, husbandman 1
4744961 2279041 2279041 plaintiff Flysshp Robert   599105 599105 Flysshp, Robert, of Tendryng 0
4744963 2279041 2279041 defendant Barker John ploughman 599105 599105 Barker, John, of Tendryng, ploughman 1
4744964 2279041 2279041 defendant Moys William yeoman 599105 599105 Moys, William, of Tendryng, yeoman 2
4744967 2279041 2279041 defendant Herman William carpenter 599105 599105 Herman, William, of Tendryng, carpenter 5
4748714 2280108 2280108 defendant Moys William yeoman 599105 599105 Moys, William, of Tendryng, yeoman 0
4795586 2294771 2294771 defendant Barkere John husbandman 599105 599105 Barkere, John, of Tendryng, husbandman 2
4832303 2306135 2306135 plaintiff Rabet Robert   599105 599105 (Rabet, Robert, of Tendryng, parson 1
4867452 2316788 2316788 defendant Mey John husbandman 599105 599105 Mey, John, of Tendryng, husbandman 0
4933194 2336773 2336773 defendant Hillys John gent 599105 599105 Hillys, John, of Tendryng, gent 1
4943956 2340075 2340075 plaintiff Gulle John   599105 599105 Gulle, John, of Tendryng 0
4968816 2347641 2347641 defendant Brampton John   599105 599105 Brampton, John, of Tendryng, servant 0
4968817 2347641 2347641 defendant Champney Roger   599105 599105 Champney, Roger, of Tendryng, servant 1
4968818 2347641 2347641 defendant Wryght William laborer 599105 599105 Wryght, William, of Tendryng, laborer 2
5123066 2393181 2393181 defendant Berforth Thomas laborer 599105 599105 Berforth, Thomas, of Tendryng, laborer 2
5168255 2406428 2406428 defendant Grove John yeoman 599105 599105 Grove, John, of Tendryng, yeoman 2
5205648 2417396 2417396 plaintiff Aunger William   599105 599105 Aunger, William, of Tendryng 1
5205651 2417396 2417396 defendant Moyse Walter husbandman 599105 599105 Moyse, Walter, of Tendryng, husbandman 0
5291921 2442643 2442643 defendant Hanham John, junior gent 599105 599105 Hanham, John, junior, of Tendryng, gent 2
5565505 2524505 2524505 defendant Porter Thomas husbandman 599105 599105 Porter, Thomas, of Tendryng, husbandman 2
5596548 2533837 2533837 defendant Coke Edmund clerk 599105 599105 Coke, Edmund, of Tendryng, clerk 0
5596549 2533837 2533837 defendant Bolle John laborer 599105 599105 Bolle, John, of Tendryng, laborer 1
5618663 2549675 2549675 defendant Noreys Thomas   599105 599105 Noreys, Thomas, of Tendryng 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);