names

61 rows where place_id = 766262

✎ 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
3615556 1872505 1872505 defendant Straesmore or Staresmor William stationer 766262 766262 Straesmore or Staresmor, William, of Walsale, Staffs, or of London, stationer 0
3834101 1968605 1968605 defendant Dyngley Richard   766262 766262 Dyngley, Richard, of Walsale, Staffs, bit maker 0
4526332 2208521 2208521 defendant Bykerton John   766262 766262 Bykerton, John, of Walsale, Staffs 0
4527417 2208852 2208852 defendant Unwyn Robert   766262 766262 Unwyn, Robert, of Walsale, Staffs 3
4742507 2278308 2278308 defendant Griffyth alias ap Sir Rees John gent 766262 766262 Griffyth alias ap Sir Rees, John, of Walsale, Staffs, gent 0
4743017 2278473 2278473 defendant Rous William yeoman 766262 766262 Rous, William, of Walsale, Staffs, yeoman 1
4759806 2283399 2283399 defendant Rous William husbandman 766262 766262 Rous, William, of Walsale, Staffs, husbandman 0
4779653 2289624 2289624 defendant Goodgrace William chapman 766262 766262 Goodgrace, William, of Walsale, Staffs, chapman 0
4792466 2293730 2293730 defendant Staresmore Thomas ironmonger 766262 766262 Staresmore, Thomas, of Walsale, Staffs, ironmonger 1
4798429 2295694 2295694 defendant Godegrace William chapman 766262 766262 Godegrace, William, of Walsale, Staffs, chapman 0
4798435 2295695 2295695 defendant Godegrace William chapman 766262 766262 Godegrace, William, of Walsale, Staffs, chapman 0
4879211 2320433 2320433 defendant Hopken John chapman 766262 766262 Hopken, John, of Walsale, Staffs, chapman 4
4887011 2322785 2322785 defendant Marchall Roger smith 766262 766262 Marchall, Roger, of Walsale, Staffs, smith 1
4895418 2325230 2325230 defendant Brydde Thomas mer4cer 766262 766262 Brydde,Thomas, of Walsale, Staffs, mer4cer 1
4908429 2329192 2329192 defendant Taillour Richard husbandman 766262 766262 Taillour, Richard, of Walsale, Staffs, husbandman 0
4924716 2334167 2334167 defendant Bryde Thomas chapman 766262 766262 Bryde, Thomas, of Walsale, Staffs, chapman 2
4924963 2334237 2334237 defendant Byrde Thomas chapman 766262 766262 Byrde, Thomas, of Walsale, Staffs, chapman 2
4932898 2336679 2336679 defendant Brown Willam chapman 766262 766262 Brown, Willam, of Walsale, Staffs, chapman 0
4952136 2342608 2342608 defendant Broun William chapman 766262 766262 Broun, William, of Walsale, Staffs, chapman 0
4952140 2342609 2342609 defendant Broun William chapman 766262 766262 Broun, William, of Walsale, Staffs, chapman 0
4971533 2348414 2348414 plaintiff Bayly John   766262 766262 Bayly, John, of Walsale, Staffs 4
4975007 2349500 2349500 defendant Glene or Gleve John tailor 766262 766262 Glene or Gleve, John, of Walsale, Staffs, tailor 0
4997498 2356103 2356103 defendant Browne John merchant 766262 766262 Browne, John, of Walsale, Staffs, merchant 1
5007391 2359054 2359054 defendant Flexhale William chapman 766262 766262 Flexhale, William, of Walsale, Staffs, chapman 3
5015927 2361549 2361549 defendant Flaxale alias Grasier William husbandman 766262 766262 Flaxale alias Grasier, William, of Walsale, Staffs, husbandman 0
5033445 2366663 2366663 defendant Wroxseter John lorimer 766262 766262 Wroxseter, John, of Walsale, Staffs, lorimer 0
5041796 2369147 2369147 defendant Browene John husbandman 766262 766262 Browene, John, of Walsale, Staffs, husbandman 2
5041815 2369151 2369151 defendant Browene John husbandman 766262 766262 Browene, John, of Walsale, Staffs, husbandman 2
5047868 2370979 2370979 defendant Kemson William   766262 766262 Kemson, William, of Walsale, Staffs, nail maker 0
5047874 2370980 2370980 defendant Kemson William   766262 766262 Kemson, William, of Walsale, Staffs, nail maker 0
5055255 2373154 2373154 defendant Flaxale William grasier 766262 766262 Flaxale, William, of Walsale, Staffs, grasier 0
5055409 2373201 2373201 defendant Flaxale William grasier 766262 766262 Flaxale, William, of Walsale, Staffs, grasier 0
5058929 2374236 2374236 defendant Rous John yeoman 766262 766262 Rous, John, of Walsale, Staffs, yeoman 0
5058931 2374237 2374237 defendant Rous John yeoman 766262 766262 Rous, John, of Walsale, Staffs, yeoman 0
5069525 2377383 2377383 defendant Flaxhale William chapman 766262 766262 Flaxhale, William, of Walsale, Staffs, chapman 1
5069983 2377517 2377517 defendant Flaxhale William chapman 766262 766262 Flaxhale, William, of Walsale, Staffs, chapman 1
5078861 2380166 2380166 defendant Rowse John drover 766262 766262 Rowse, John, of Walsale, Staffs, drover 0
5079465 2380350 2380350 defendant Graygose Roger chaplain 766262 766262 Graygose, Roger, of Walsale, Staffs, chaplain 0
5079467 2380351 2380351 defendant Greygoos Roger chaplain 766262 766262 Greygoos, Roger, of Walsale, Staffs, chaplain 0
5086846 2382549 2382549 defendant Petirburgh Thomas carrier 766262 766262 Petirburgh, Thomas, of Walsale, Staffs, carrier 2
5114386 2390603 2390603 defendant Mersh John ironmonger 766262 766262 Mersh, John, of Walsale, Staffs, ironmonger 1
5240568 2427455 2427455 defendant Hornby Nicholas drover 766262 766262 Hornby, Nicholas, of Walsale, Staffs, drover 0
5320847 2451323 2451323 defendant Gunstyn William carrier 766262 766262 Gunstyn, William, of Walsale, Staffs, carrier 1
5322610 2451841 2451841 defendant Taylour William yeoman 766262 766262 Taylour, William, of Walsale, Staffs, yeoman 1
5322613 2451842 2451842 defendant Taylour William yeoman 766262 766262 Taylour, William, of Walsale, Staffs, yeoman 1
5330106 2454080 2454080 defendant Wrasteler William yeoman 766262 766262 Wrasteler, William, of Walsale, Staffs, husbandman, or of Dordon, Warks, yeoman 0
5337718 2456353 2456353 defendant Flaxhale John gent 766262 766262 Flaxhale, John, of Walsale, Staffs, gent 2
5353650 2461212 2461212 defendant Patyngeham Thomas yeoman 766262 766262 Patyngeham, Thomas, of Walsale, Staffs, yeoman 1
5353656 2461213 2461213 defendant Patyngeham Thomas yeoman 766262 766262 Patyngeham, Thomas, of Walsale, Staffs, yeoman 1
5446933 2488977 2488977 defendant Dadston John chapman 766262 766262 Dadston, John, of Walsale, Staffs, chapman 0
5449909 2489860 2489860 defendant Staresmore Roger, junior ironmonger 766262 766262 Staresmore, Roger, junior, of Walsale, Staffs, ironmonger 1
5459488 2492750 2492750 defendant Dalston John chapman 766262 766262 Dalston, John, of Walsale, Staffs, chapman 0
5471233 2496334 2496334 defendant Dalston John chapman 766262 766262 Dalston, John, of Walsale, Staffs, chapman 0
5476742 2498045 2498045 defendant Patenham Thomas (legal representative) 766262 766262 Patenham, Thomas, of Walsale, Staffs, yeoman, administratrix of 1
5478422 2498571 2498571 defendant Blokyswyche William barker 766262 766262 Blokyswyche, William, of Walsale, Staffs, barker 7
5482484 2499703 2499703 defendant Dalston John chapman 766262 766262 Dalston, John, of Walsale, Staffs, chapman 0
5488229 2501378 2501378 defendant Patencham Thomas (legal representative) 766262 766262 Patencham, Thomas, of Walsale, Staffs, yeoman, administratrix of 1
5488233 2501379 2501379 defendant Patenham Thomas (legal representative) 766262 766262 Patenham, Thomas, of Walsale, Staffs, yeoman, administratrix of 1
5581110 2529161 2529161 defendant Starismour William gent 766262 766262 Starismour, William, of Walsale, Staffs, gent 1
5581117 2529162 2529162 defendant Starismour William gent 766262 766262 Starismour, William, of Walsale, Staffs, gent 0
5632848 2554282 2554282 defendant Shelfeld Robert ironmonger 766262 766262 Shelfeld, Robert, of Walsale, Staffs, ironmonger 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);