names

51 rows where place_id = 594946

✎ 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
3618227 1873325 1873325 defendant Bardall John husbandman 594946 594946 Bardall, John, of Abbots Bromley, husbandman 0
3618228 1873325 1873325 defendant Walker Humphrey husbandman 594946 594946 Walker, Humphrey, of Abbots Bromley, husbandman 1
3626524 1903147 1903147 defendant Edwardes Richard yeoman 594946 594946 Edwardes, Richard, of Abbots Bromley, yeoman 0
3626525 1903147 1903147 defendant Lowne William yeoman 594946 594946 Lowne, William, of Abbots Bromley, yeoman 1
3626526 1903147 1903147 defendant Hervy Richard glassmaker 594946 594946 Hervy, Richard, of Abbots Bromley, glassmaker 2
3706124 1928208 1928208 defendant Barlowe William tailor 594946 594946 Barlowe, William, of Abbots Bromley, tailor 2
3797940 1957254 1957254 defendant Alsop Thomas husbandman 594946 594946 Alsop, Thomas, of Abbots Bromley, husbandman 2
3946890 2005981 2005981 defendant Harvy Cedda carrier 594946 594946 Harvy, Cedda, of Abbots Bromley, carrier 0
3962336 2011410 2011410 defendant More Richard butcher 594946 594946 More, Richard, of Abbots Bromley, butcher 0
4078653 2052662 2052662 defendant Porter John glasier 594946 594946 Porter, John, of Abbots Bromley, glasier 1
4078654 2052662 2052662 defendant Banck John glasier 594946 594946 Banck, John, of Abbots Bromley, glasier 2
4419098 2170839 2170839 plaintiff atte Hoke Richard   594946 594946 atte Hoke, Richard, of Abbots Bromley 0
4443319 2182872 2182872 plaintiff Carter William   594946 594946 Carter, William, of Abbots Bromley 0
4488501 2197124 2197124 defendant Milde John, junior   594946 594946 Milde, John, junior, of Abbots Bromley 1
4489228 2197347 2197347 defendant Chapman Robert   594946 594946 Chapman, Robert, of Abbots Bromley 1
4547844 2215263 2215263 plaintiff Cartwryght William   594946 594946 Cartwryght, William, of Abbots Bromley 0
4609745 2234141 2234141 defendant Hambury John   594946 594946 Hambury, John, of Abbots Bromley 0
4820866 2302613 2302613 defendant Webbe William yeoman 594946 594946 Webbe, William, of Abbots Bromley, yeoman 0
5014087 2360973 2360973 defendant Dycon John shingler 594946 594946 Dycon, John, of Abbots Bromley, shingler 2
5052413 2372321 2372321 defendant Coke John glasier 594946 594946 Coke, John, of Abbots Bromley, glasier 3
5052419 2372322 2372322 defendant Coke John glasier 594946 594946 Coke, John, of Abbots Bromley, glasier 3
5060055 2374573 2374573 defendant Merton John laborer 594946 594946 Merton, John, of Abbots Bromley, laborer 0
5061363 2374982 2374982 defendant Lambart John mercer 594946 594946 Lambart, John, of Abbots Bromley, mercer 3
5067294 2376727 2376727 defendant Lambert John mercer 594946 594946 Lambert, John, of Abbots Bromley, mercer 0
5067295 2376727 2376727 defendant Forster Richard barker 594946 594946 Forster, Richard, of Abbots Bromley, barker 1
5067296 2376727 2376727 defendant Banastre Nicholas barker 594946 594946 Banastre, Nicholas, of Abbots Bromley, barker 2
5067297 2376727 2376727 defendant Bardell William husbandman 594946 594946 Bardell, William, of Abbots Bromley, husbandman 3
5103585 2387476 2387476 defendant Newton Robert glasier 594946 594946 Newton, Robert, of Abbots Bromley, glasier 0
5131651 2395738 2395738 defendant Clerk Thomas   594946 594946 Clerk, Thomas, of Abbots Bromley 0
5183158 2410813 2410813 defendant Aberley John yeoman 594946 594946 Aberley, John, of Abbots Bromley, yeoman 2
5258320 2432719 2432719 defendant Shene John, senior yeoman 594946 594946 Shene, John, senior, of Abbots Bromley, yeoman 0
5258321 2432719 2432719 defendant Shene John, junior yeoman 594946 594946 Shene, John, junior, of Abbots Bromley, yeoman 1
5258322 2432719 2432719 defendant Shene William yeoman 594946 594946 Shene, William, of Abbots Bromley, yeoman 2
5258323 2432719 2432719 defendant Marries George tailor 594946 594946 Marries, George, of Abbots Bromley, tailor 3
5258324 2432719 2432719 defendant Couper Richard carver 594946 594946 Couper, Richard, of Abbots Bromley, carver 4
5258325 2432719 2432719 defendant Couper Roger carver 594946 594946 Couper, Roger, of Abbots Bromley, carver 5
5258326 2432719 2432719 defendant Pyper Richard laborer 594946 594946 Pyper, Richard, of Abbots Bromley, laborer 6
5258327 2432719 2432719 defendant Brome William laborer 594946 594946 Brome, William, of Abbots Bromley, laborer 7
5280212 2439287 2439287 defendant Lambert Robert husbandman 594946 594946 Lambert, Robert, of Abbots Bromley, husbandman 0
5289285 2441869 2441869 defendant Lambard Robert yeoman 594946 594946 Lambard, Robert, of Abbots Bromley, yeoman 0
5289287 2441870 2441870 defendant Lambard Robert yeoman 594946 594946 Lambard, Robert, of Abbots Bromley, yeoman 0
5292855 2442902 2442902 defendant Haselhorst Benedict yeoman 594946 594946 Haselhorst, Benedict, of Abbots Bromley, yeoman 0
5292856 2442902 2442902 defendant Dunne William yeoman 594946 594946 Dunne, William, of Abbots Bromley, yeoman 1
5292857 2442902 2442902 defendant Pekkesley John yeoman 594946 594946 Pekkesley, John, of Abbots Bromley, yeoman 2
5292858 2442902 2442902 defendant Hawardyne John yeoman 594946 594946 Hawardyne, John, of Abbots Bromley, yeoman 3
5506795 2507045 2507045 defendant Pulesdon John yeoman 594946 594946 Pulesdon, John, of Abbots Bromley, yeoman 0
5508106 2507425 2507425 defendant Bradshawe Hugh yeoman 594946 594946 Bradshawe, Hugh, of Abbots Bromley, yeoman 2
5508110 2507426 2507426 defendant Bradshawe Hugh yeoman 594946 594946 Bradshawe, Hugh, of Abbots Bromley, yeoman 2
5508114 2507427 2507427 defendant Brodshawe Hugh yeoman 594946 594946 Brodshawe, Hugh, of Abbots Bromley, yeoman 2
5515069 2509558 2509558 defendant Arnald Thomas husbandman 594946 594946 Arnald, Thomas, of Abbots Bromley, husbandman 0
5594298 2533192 2533192 defendant Dey Richard husbandman 594946 594946 Dey, Richard, of Abbots Bromley, husbandman 3

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