names

55 rows where place_id = 590843

✎ 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
3596301 1866472 1866472 defendant Swyft John   590843 590843 Swyft, John, of Byrmyngeham, scythe maker 2
3599633 1867528 1867528 defendant Swyft John   590843 590843 Swyft, John, of Byrmyngeham, scythe maker 1
3602482 1868437 1868437 defendant Squyer Henry chapman 590843 590843 Squyer, Henry, of Byrmyngeham, chapman 0
3630170 1904286 1904286 defendant Segewyke William yeoman 590843 590843 Segewyke, William, of Byrmyngeham, yeoman 0
3654953 1911811 1911811 defendant Neele Henry sporyer 590843 590843 Neele, Henry, of Byrmyngeham, sporyer 0
3662016 1914052 1914052 defendant Eliottes John yeoman 590843 590843 Eliottes, John, of Byrmyngeham, yeoman 0
3676235 1918614 1918614 defendant Graunger Stephen tanner 590843 590843 Graunger, Stephen, of Byrmyngeham, tanner 1
3692618 1923879 1923879 defendant Swyfte John (legal representative) 590843 590843 Swyfte, John, of Byrmyngeham, scythe smith, executors of 0
3692619 1923879 1923879 defendant Smyth alias Hosyer John yeoman 590843 590843 (Smyth alias Hosyer, John, of Byrmyngeham, yeoman 1
3722501 1933298 1933298 defendant Byrmyngeham William gent 590843 590843 Byrmyngeham, William, of Byrmyngeham, gent 0
3722507 1933299 1933299 defendant Tofte John husbandman 590843 590843 Tofte, John, of Byrmyngeham, husbandman 1
3722512 1933300 1933300 defendant Byrmyngeham William gent 590843 590843 Byrmyngeham, William, of Byrmyngeham, gent 1
3729352 1935433 1935433 defendant Arcolde John barber 590843 590843 Arcolde, John, of Byrmyngeham, barber 0
3752591 1942739 1942739 defendant Wygstede John butcher 590843 590843 Wygstede, John, of Byrmyngeham, butcher 0
3755706 1943745 1943745 defendant Colmer William mercer 590843 590843 Colmer, William, of Byrmyngeham, mercer 0
3773243 1949339 1949339 defendant Hundrythshillyngys Francis painter 590843 590843 Hundrythshillyngys, Francis, of Byrmyngeham, painter 0
3803909 1959135 1959135 defendant Furniffall Richard esq 590843 590843 Furniffall, Richard, of Byrmyngeham, esq 0
3809999 1961015 1961015 defendant Lynde Oliver mercer 590843 590843 Lynde, Oliver, of Byrmyngeham, mercer 0
3818386 1963649 1963649 defendant Lynde Oliver mercer 590843 590843 Lynde, Oliver, of Byrmyngeham, mercer 0
3855174 1975251 1975251 defendant Tofte Edward master of St Thomas Martyr Hospital 590843 590843 Tofte, Edward, of Byrmyngeham, clerk, master of St Thomas Martyr Hospital 3
3855179 1975252 1975252 defendant Tofte Edward master of St Thomas Martyr Hospital 590843 590843 Tofte, Edward, of Byrmyngeham, clerk, master of St Thomas Martyr Hospital 3
3857729 1976053 1976053 defendant Hervy Thomas yeoman 590843 590843 Hervy, Thomas, of Byrmyngeham, yeoman 2
3863829 1978077 1978077 defendant Wygsted John butcher 590843 590843 Wygsted, John, of Byrmyngeham, butcher 0
3866528 1979035 1979035 defendant Shelton John chapman 590843 590843 Shelton, John, of Byrmyngeham, chapman 0
4513043 2204514 2204514 defendant Bocher John   590843 590843 Bocher, John, of Byrmyngeham 0
4728895 2274275 2274275 defendant Em John cooper 590843 590843 Em, John, of Byrmyngeham, cooper 4
4732450 2275323 2275323 defendant Couper John cooper 590843 590843 Couper, John, of Byrmyngeham, cooper 0
4942187 2339544 2339544 defendant Harrys Henry drover 590843 590843 Harrys, Henry, of Byrmyngeham, drover 0
4945503 2340573 2340573 defendant Bradewell John husbandman 590843 590843 Bradewell, John, of Byrmyngeham, husbandman 0
5114933 2390782 2390782 defendant Hyet Thomas smith 590843 590843 Hyet, Thomas, of Byrmyngeham, smith 1
5217166 2420756 2420756 defendant Exhale John smith 590843 590843 Exhale, John, of Byrmyngeham, smith 1
5236924 2426380 2426380 defendant Phelippes William tailor 590843 590843 Phelippes, William, of Byrmyngeham, tailor 2
5276829 2438305 2438305 defendant Gate William butcher 590843 590843 Gate, William, of Byrmyngeham, butcher 0
5280255 2439303 2439303 plaintiff Butteler Thomas   590843 590843 Butteler, Thomas, of Byrmyngeham 0
5314412 2449337 2449337 defendant Chesshyre John smith 590843 590843 Chesshyre, John, of Byrmyngeham, smith 1
5346858 2459175 2459175 defendant Phelippes William yeoman 590843 590843 Phelippes, William, of Byrmyngeham, yeoman 0
5349293 2459907 2459907 defendant Byrmyngeham Agnes widow 590843 590843 Byrmyngeham, Agnes, of Byrmyngeham, widow 0
5352732 2460944 2460944 plaintiff Forster Henry   590843 590843 Forster, Henry, of Byrmyngeham 0
5354262 2461398 2461398 defendant Flete alias Lloyte Richard chapman 590843 590843 Flete alias Lloyte, Richard, of Byrmyngeham, chapman 0
5354264 2461399 2461399 defendant Flete alias Lloyte Richard chapman 590843 590843 Flete alias Lloyte, Richard, of Byrmyngeham, chapman 0
5361924 2463755 2463755 defendant Blower Thomas mercer 590843 590843 Blower, Thomas, of Byrmyngeham, mercer 0
5404644 2476403 2476403 defendant Conwey Lewis drover 590843 590843 Conwey, Lewis, of Byrmyngeham, drover 0
5506233 2506871 2506871 defendant Jaynkyns Thomas laborer 590843 590843 Jaynkyns, Thomas, of Byrmyngeham, laborer 0
5506234 2506871 2506871 defendant Jaynkyns John laborer 590843 590843 Jaynkyns, John, of Byrmyngeham, laborer 1
5506235 2506871 2506871 defendant Broun Thomas smith 590843 590843 Broun, Thomas, of Byrmyngeham, smith 2
5506236 2506871 2506871 defendant Persons William laborer 590843 590843 Persons, William, of Byrmyngeham, laborer 3
5519911 2511065 2511065 defendant Bandryke or Baudryke Humphrey yeoman 590843 590843 Bandryke or Baudryke, Humphrey, of Byrmyngeham, yeoman 1
5519912 2511065 2511065 defendant Broun Mathew smith 590843 590843 Broun, Mathew, of Byrmyngeham, smith 2
5530023 2513898 2513898 defendant Gest Richard yeoman 590843 590843 Gest, Richard, of Byrmyngeham, yeoman 1
5531606 2514417 2514417 defendant Midwynter Thomas mercer 590843 590843 Midwynter, Thomas, of Byrmyngeham, mercer 0
5538134 2516415 2516415 defendant Broun John smith 590843 590843 Broun, John, of Byrmyngeham, smith 0
5538140 2516416 2516416 defendant Broun John smith 590843 590843 Broun, John, of Byrmyngeham, smith 0
5566815 2524888 2524888 defendant Wyette William tanner 590843 590843 Wyette, William, of Byrmyngeham, tanner 0
5566816 2524888 2524888 defendant Perre John tanner 590843 590843 Perre, John, of Byrmyngeham, tanner 1
5567416 2525050 2525050 defendant Lenche John   590843 590843 Lenche, John, of Byrmyngeham, scythe smith 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);