names

47 rows where place_id = 609202

✎ 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
3677459 1919001 1919001 defendant Bowman Richard clothier 609202 609202 Bowman, Richard, of Birmingham, Warks, clothier 0
3963189 2011726 2011726 defendant Unett or Vuett Gilbert yeoman 609202 609202 (Unett or Vuett, Gilbert, of Birmingham, Warks, yeoman 1
4021452 2032396 2032396 defendant Jelleff William yeoman or hardwareman 609202 609202 Jelleff, William, of Birmingham, Warks, yeoman or hardwareman 0
4021456 2032397 2032397 defendant Jolyff Thomas   609202 609202 Jolyff, Thomas, of Birmingham, Warks, yeoman, hardware maker 0
4026904 2034272 2034272 defendant Toley John gent 609202 609202 Toley, John, of Birmingham, Warks, gent 0
4029649 2035242 2035242 plaintiff Davys Roger lorimer 609202 609202 Davys, Roger, of Birmingham, Warks, lorimer 0
4041520 2039458 2039458 defendant Rastell Thomas draper 609202 609202 Rastell, Thomas, of Birmingham, Warks, draper 0
4041526 2039461 2039461 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4041528 2039462 2039462 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4041813 2039553 2039553 defendant Rastell Thomas draper 609202 609202 Rastell, Thomas, of Birmingham, Warks, draper 0
4047513 2041563 2041563 defendant Cotterell Edward cutler 609202 609202 Cotterell, Edward, of Birmingham, Warks, cutler 0
4047676 2041617 2041617 defendant Jelliffe alias Gelly William carrier 609202 609202 Jelliffe alias Gelly, William, of Birmingham, Warks, carrier 0
4051064 2042818 2042818 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4051065 2042819 2042819 plaintiff Whitall Robert mercer 609202 609202 Whitall, Robert, of Birmingham, Warks, mercer 0
4051175 2042858 2042858 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4051612 2042997 2042997 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4051614 2042998 2042998 defendant Rastell John draper 609202 609202 Rastell, John, of Birmingham, Warks, draper 0
4052279 2043239 2043239 defendant Jelley William hardwareman 609202 609202 Jelley, William, of Birmingham, Warks, hardwareman 0
4052298 2043243 2043243 defendant Jelley William hardwareman 609202 609202 Jelley, William, of Birmingham, Warks, hardwareman 0
4054448 2043979 2043979 defendant Carre Richard carrier 609202 609202 Carre, Richard, of Birmingham, Warks, carrier 0
4062921 2047040 2047040 defendant Jellye William chapman 609202 609202 Jellye, William, of Birmingham, Warks, chapman 0
4070992 2049924 2049924 plaintiff Milner or Miller Thomas shoemaker 609202 609202 Milner or Miller, Thomas, of Birmingham, Warks, shoemaker 0
4071625 2050147 2050147 defendant Rychard Reginald butcher 609202 609202 Rychard, Reginald, of Birmingham, Warks, butcher 0
4078322 2052547 2052547 plaintiff Symonde Thoms   609202 609202 Symonde, Thoms, of Birmingham, Warks, gent, administrators of 0
4091053 2057090 2057090 defendant Rychard Reginald butcher 609202 609202 Rychard, Reginald, of Birmingham, Warks, butcher 0
4100814 2060607 2060607 defendant Car Thomas yeoman 609202 609202 Car, Thomas, of Birmingham, Warks, yeoman 0
4104300 2061817 2061817 plaintiff Milward John yeoman or cutler 609202 609202 Milward, John, of Birmingham, Warks, yeoman or cutler 0
4112124 2064594 2064594 defendant Smythe Thomas yeoman 609202 609202 Smythe, Thomas, of Birmingham, Warks, yeoman 0
4120901 2067764 2067764 defendant Carr Richard yeoman 609202 609202 Carr, Richard, of Birmingham, Warks, yeoman 2
4127048 2069964 2069964 defendant Carre Richard carrier 609202 609202 Carre, Richard, of Birmingham, Warks, carrier 0
4147576 2077294 2077294 defendant Heath John sherman 609202 609202 Heath, John, of Birmingham, Warks, sherman 1
4147712 2077343 2077343 defendant Heath John sherman 609202 609202 Heath, John, of Birmingham, Warks, sherman 1
4207743 2098271 2098271 defendant Cowper Thomas, senior yeoman 609202 609202 Cowper, Thomas, senior, of Birmingham, Warks, yeoman 0
4212395 2099884 2099884 defendant Cowper Thomas chapman 609202 609202 Cowper, Thomas, of Birmingham, Warks, chapman 0
4266956 2118590 2118590 defendant Hall William sherman 609202 609202 Hall, William, of Birmingham, Warks, sherman 0
4318556 2136602 2136602 defendant Leather Richard cutler 609202 609202 Leather, Richard, of Birmingham, Warks, cutler 0
4330814 2140604 2140604 defendant Hullye William lorimer 609202 609202 Hullye, William, of Birmingham, Warks, lorimer 0
4361796 2151378 2151378 defendant Blocksidge William yeoman 609202 609202 Blocksidge, William, of Birmingham, Warks, yeoman 0
4367598 2153465 2153465 defendant Newy John   609202 609202 Newy, John, of Birmingham, Warks, bellows maker 2
4388540 2160810 2160810 defendant Smyth Nicholas draper 609202 609202 Smyth, Nicholas, of Birmingham, Warks, draper 0
4388545 2160811 2160811 defendant Mylward John innkeeper 609202 609202 Mylward, John, of Birmingham, Warks, innkeeper 0
4398609 2164114 2164114 defendant Cynney or Bynney Gertude cutler 609202 609202 Cynney or Bynney, Gertude, of Birmingham, Warks, cutler 1
4410266 2168032 2168032 defendant Cowper Thomas chapman 609202 609202 Cowper, Thomas, of Birmingham, Warks, chapman 0
4651012 2246317 2246317 defendant Bernebrok Thomas chapman 609202 609202 Bernebrok, Thomas, of Birmingham, Warks, chapman 2
4651018 2246318 2246318 defendant Bernebrok Thomas chapman 609202 609202 Bernebrok, Thomas, of Birmingham, Warks, chapman 2
4657958 2248373 2248373 defendant Smalbroke John   609202 609202 Smalbroke, John, of Birmingham, Warks, wire drawer 2
5503583 2506034 2506034 defendant Couper John cooper 609202 609202 Couper, John, of Birmingham, Warks, cooper 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);