names

51 rows where place_id = 596830

✎ 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
3626327 1903092 1903092 defendant Padley Roger chapman 596830 596830 Padley, Roger, of Rotherham, Yorks, chapman 2
3646550 1909322 1909322 defendant Gurry William yeoman 596830 596830 Gurry, William, of Rotherham, Yorks, yeoman 0
3646553 1909323 1909323 plaintiff Hardy William pewterer 596830 596830 Hardy, William, of Rotherham, Yorks, pewterer 1
3715078 1931012 1931012 defendant Brodehirst George merchant tailor 596830 596830 Brodehirst, George, of Rotherham, Yorks, merchant tailor 0
3771338 1948727 1948727 defendant Brodeherst George, junior merchant 596830 596830 Brodeherst, George, junior, of Rotherham, Yorks, merchant 0
3791883 1955308 1955308 defendant Gylle Thomas dyer 596830 596830 Gylle, Thomas, of Rotherham, Yorks, dyer 0
3791888 1955310 1955310 defendant Gylle Thomas dyer 596830 596830 Gylle, Thomas, of Rotherham, Yorks, dyer 0
3792647 1955559 1955559 defendant Padley Roger chapman 596830 596830 Padley, Roger, of Rotherham, Yorks, chapman 0
3808874 1960656 1960656 defendant Podley Roger chapman 596830 596830 Podley, Roger, of Rotherham, Yorks, chapman 1
3939957 2003664 2003664 defendant Snell John merchant 596830 596830 Snell, John, of Rotherham, Yorks, merchant 0
4082073 2053885 2053885 defendant Oke Jasper yeoman 596830 596830 Oke, Jasper, of Rotherham, Yorks, yeoman 0
4256278 2115078 2115078 defendant Dickenson Thomas pewterer 596830 596830 Dickenson, Thomas, of Rotherham, Yorks, pewterer 0
4276373 2121680 2121680 defendant Corker Robert chapman 596830 596830 Corker, Robert, of Rotherham, Yorks, yeoman, chapman 1
4279668 2122807 2122807 defendant Pennell William gent 596830 596830 Pennell, William, of Rotherham, Yorks, gent 0
4698796 2265104 2265104 defendant Walker John yeoman 596830 596830 Walker, John, of Rotherham, Yorks, yeoman 0
4703027 2266329 2266329 defendant West John gent 596830 596830 West, John, of Rotherham, Yorks, gent 3
4727676 2273898 2273898 defendant West John yeoman 596830 596830 West, John, of Rotherham, Yorks, yeoman 1
4759117 2283199 2283199 defendant Welowes John dyer 596830 596830 Welowes, John, of Rotherham, Yorks, dyer 2
4768962 2286271 2286271 defendant Skany Thomas chapman 596830 596830 Skany, Thomas, of Rotherham, Yorks, chapman 0
4812741 2300100 2300100 defendant Wyllowys John dyer 596830 596830 Wyllowys, John, of Rotherham, Yorks, dyer 0
4897470 2325871 2325871 defendant Barnby Hugh chapman 596830 596830 Barnby, Hugh, of Rotherham, Yorks, chapman 0
4900676 2326852 2326852 defendant Scote Robert   596830 596830 Scote, Robert, of Rotherham, Yorks, "saudeour" or soldier 0
4923604 2333816 2333816 defendant Wolhouse William ironmonger 596830 596830 Wolhouse, William, of Rotherham, Yorks, ironmonger 2
4993338 2354878 2354878 defendant Blount Richard tailor 596830 596830 Blount, Richard, of Rotherham, Yorks, tailor 1
5025155 2364254 2364254 defendant Scotte William chapman 596830 596830 Scotte, William, of Rotherham, Yorks, chapman 0
5040691 2368828 2368828 defendant Weyng Thomas chapman 596830 596830 Weyng, Thomas, of Rotherham, Yorks, chapman 0
5040692 2368828 2368828 defendant Wylcok Richard yeoman 596830 596830 Wylcok, Richard, of Rotherham, Yorks, yeoman 1
5127804 2394609 2394609 defendant Byrle Willliam taverner 596830 596830 Byrle, Willliam, of Rotherham, Yorks, taverner 1
5146845 2400217 2400217 defendant Byrle William taver 596830 596830 Byrle, William, of Rotherham, Yorks, taver 1
5180829 2410135 2410135 defendant Byrley William yeoman 596830 596830 Byrley, William, of Rotherham, Yorks, yeoman 0
5180894 2410154 2410154 defendant Byrley William yeoman 596830 596830 Byrley, William, of Rotherham, Yorks, yeoman 0
5197043 2414878 2414878 defendant Lytster Richard husbandman alias arrow maker 596830 596830 Lytster, Richard, of Rotherham, Yorks, husbandman alias arrow maker 0
5202592 2416522 2416522 defendant Byrley William yeoman 596830 596830 Byrley, William, of Rotherham, Yorks, yeoman 0
5202594 2416523 2416523 defendant Byrley William yeoman 596830 596830 Byrley, William, of Rotherham, Yorks, yeoman 0
5275112 2437799 2437799 defendant Boydall Nicholas   596830 596830 Boydall, Nicholas, of Rotherham, Yorks 0
5311114 2448355 2448355 defendant Hynkersale John chapman 596830 596830 Hynkersale, John, of Rotherham, Yorks, chapman 1
5311120 2448356 2448356 defendant Hynkersale John chapman 596830 596830 Hynkersale, John, of Rotherham, Yorks, chapman 1
5339595 2456958 2456958 defendant Lylly Robert husbandman 596830 596830 Lylly, Robert, of Rotherham, Yorks, husbandman 1
5413859 2479069 2479069 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 2
5418243 2480381 2480381 defendant Gurry William innholder 596830 596830 Gurry, William, of Rotherham, Yorks, innholder 0
5422967 2481822 2481822 defendant Payly Richard dyer 596830 596830 Payly, Richard, of Rotherham, Yorks, dyer 0
5424416 2482269 2482269 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 2
5427791 2483270 2483270 defendant Holden Robert mercer 596830 596830 Holden, Robert, of Rotherham, Yorks, mercer 0
5429265 2483681 2483681 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 2
5429269 2483682 2483682 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 2
5441049 2487232 2487232 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 2
5442438 2487654 2487654 defendant Payly Richard dyer 596830 596830 Payly, Richard, of Rotherham, Yorks, dyer 0
5533196 2514933 2514933 defendant Holden Robert chapman 596830 596830 Holden, Robert, of Rotherham, Yorks, chapman 1
5597244 2534048 2534048 defendant Hanson John (legal representative) 596830 596830 Hanson, John, of Rotherham, Yorks, yeoman, administratrix of 2
5598682 2534461 2534461 defendant Kyngesley John dyer 596830 596830 Kyngesley, John, of Rotherham, Yorks, dyer 0
5598685 2534462 2534462 defendant Kyngesley John dyer 596830 596830 Kyngesley, John, of Rotherham, Yorks, dyer 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);