names

44 rows where place_id = 647970

✎ 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
3899195 1989937 1989937 defendant Melburne Arthur laborer 647970 647970 Melburne, Arthur, of Glentham, laborer 0
3914319 1995132 1995132 defendant Mylburn Arthur laborer 647970 647970 Mylburn, Arthur, of Glentham, laborer 0
3915433 1995528 1995528 defendant Malkynson Oliver husbandman 647970 647970 Malkynson, Oliver, of Glentham, husbandman 0
3957501 2009690 2009690 defendant Nayler Edward yeoman 647970 647970 Nayler, Edward, of Glentham, yeoman 0
3967333 2013203 2013203 defendant Nayler Edward yeoman 647970 647970 Nayler, Edward, of Glentham, yeoman 4
3987564 2020302 2020302 defendant Twydall or Wydall Thomas yeoman 647970 647970 Twydall or Wydall, Thomas, of Glentham, yeoman 1
3992562 2022092 2022092 defendant Twydall Thomas yeoman 647970 647970 Twydall, Thomas, of Glentham, yeoman 1
3992578 2022096 2022096 defendant Twydall Thomas gent 647970 647970 Twydall, Thomas, of Glentham, gent 0
3992598 2022101 2022101 defendant Lamyng John yeoman 647970 647970 Lamyng, John, of Glentham, yeoman 0
3992607 2022103 2022103 defendant Twydall Thomas yeoman 647970 647970 Twydall, Thomas, of Glentham, yeoman 1
4074936 2051336 2051336 defendant Lamynge Richard clerk 647970 647970 Lamynge, Richard, of Glentham, clerk 2
4130380 2071178 2071178 defendant Twidale Thomas yeoman 647970 647970 Twidale, Thomas, of Glentham, yeoman 0
4153871 2079449 2079449 defendant Twidall Thomas yeoman 647970 647970 Twidall, Thomas, of Glentham, yeoman 0
4178258 2087867 2087867 defendant Twidale Thomas yeoman 647970 647970 Twidale, Thomas, of Glentham, yeoman 0
4232368 2106829 2106829 defendant Thorye Thomas yeoman 647970 647970 Thorye, Thomas, of Glentham, yeoman 0
4241098 2110008 2110008 defendant Thorye Thomas yeoman 647970 647970 Thorye, Thomas, of Glentham, yeoman 0
4263828 2117561 2117561 defendant Twidell Thomas yeoman 647970 647970 Twidell, Thomas, of Glentham, yeoman 2
4288541 2125952 2125952 defendant Thore Thomas yeoman 647970 647970 Thore, Thomas, of Glentham, yeoman 1
4360561 2150945 2150945 defendant Twidall Mark yeoman 647970 647970 Twidall, Mark, of Glentham, yeoman 3
4361364 2151227 2151227 defendant Twidall Thomas yeoman 647970 647970 Twidall, Thomas, of Glentham, yeoman 0
4432536 2174945 2174945 plaintiff Darcy William   647970 647970 Darcy, William, of Glentham 0
4468102 2190696 2190696 defendant Riby John   647970 647970 Riby, John, of Glentham 2
4547884 2215274 2215274 defendant Redburn Roger   647970 647970 Redburn, Roger, of Glentham 4
4650157 2246067 2246067 defendant Lavun John   647970 647970 Lavun, John, of Glentham 0
4673813 2257433 2257433 defendant Appeley John butcher 647970 647970 Appeley, John, of Glentham, butcher 0
4727036 2273720 2273720 defendant Catton William yeoman 647970 647970 Catton, William, of Glentham, yeoman 0
4727074 2273728 2273728 defendant Chaumbre John gent 647970 647970 Chaumbre, John, of Glentham, gent 3
4816090 2301125 2301125 defendant Appeley John butcher 647970 647970 Appeley, John, of Glentham, butcher 0
4869233 2317344 2317344 defendant Barton John yeoman 647970 647970 Barton, John, of Glentham, yeoman 11
4882792 2321540 2321540 defendant Toweton John husbandman 647970 647970 Toweton, John, of Glentham, husbandman 2
4899025 2326337 2326337 defendant Arplay John butcher 647970 647970 Arplay, John, of Glentham, butcher 0
4909883 2329614 2329614 defendant Appley John butcher 647970 647970 Appley, John, of Glentham, butcher 0
4967946 2347356 2347356 defendant Byrkwode William husbandman 647970 647970 Byrkwode, William, of Glentham, husbandman 2
4967955 2347357 2347357 defendant Goldesburgh Thomas husbandman 647970 647970 Goldesburgh, Thomas, of Glentham, husbandman 4
5021451 2363182 2363182 defendant Thaker John husbandman 647970 647970 Thaker, John, of Glentham, husbandman 1
5267141 2435481 2435481 plaintiff Wilkynson William   647970 647970 Wilkynson, William, of Glentham 0
5285709 2440847 2440847 defendant Couper Thomas husbandman 647970 647970 Couper, Thomas, of Glentham, husbandman 4
5317643 2450364 2450364 plaintiff Forman Robert gent 647970 647970 Forman, Robert, of Glentham, gent 0
5382899 2470176 2470176 defendant Hyget William husbandman 647970 647970 Hyget, William, of Glentham, husbandman 0
5382901 2470176 2470176 defendant Hyget John husbandman 647970 647970 Hyget, John, of Glentham, husbandman 2
5393749 2473273 2473273 defendant Hyget William husbandman 647970 647970 Hyget, William, of Glentham, husbandman 0
5393753 2473273 2473273 defendant Hyget John   647970 647970 Hyget, John, of Glentham 4
5393755 2473274 2473274 defendant Hyget William husbandman 647970 647970 Hyget, William, of Glentham, husbandman 0
5393759 2473274 2473274 defendant Hyget John   647970 647970 Hyget, John, of Glentham 4

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