names

43 rows where place_id = 615584

✎ 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
3592053 1865131 1865131 defendant Cole John husbandman 615584 615584 Cole, John, of Halesowen, Salop, innholder, or of Belbroughton, Worcs, husbandman 0
3709590 1929309 1929309 defendant Hasewald William husbandman 615584 615584 Hasewald, William, of Halesowen, Salop, husbandman 0
3709595 1929310 1929310 defendant Hasewold William husbandman 615584 615584 Hasewold, William, of Halesowen, Salop, husbandman 0
3791358 1955133 1955133 defendant Tollet Henry tanner 615584 615584 Tollet, Henry, of Halesowen, Salop, tanner 1
3847287 1972712 1972712 defendant Hawkys William husbandman 615584 615584 Hawkys, William, of Halesowen, Salop, husbandman 2
3852844 1974498 1974498 defendant Rowley William yeoman 615584 615584 Rowley, William, of Halesowen, Salop, yeoman 1
3866003 1978863 1978863 defendant Walle Anthony mercer 615584 615584 Walle, Anthony, of Halesowen, Salop, mercer 3
3895481 1988698 1988698 defendant Cokes William dyer 615584 615584 Cokes, William, of Halesowen, Salop, dyer 0
3901243 1990640 1990640 defendant Mulklowe William husbandman 615584 615584 Mulklowe, William, of Halesowen, Salop, husbandman 0
3904439 1991731 1991731 defendant Mowselay Edward carpenter 615584 615584 Mowselay, Edward, of Halesowen, Salop, carpenter 0
3965040 2012376 2012376 plaintiff Bankes William nailer 615584 615584 Bankes, William, of Halesowen, Salop, nailer 0
3970267 2014196 2014196 plaintiff Darbye John yeoman 615584 615584 Darbye, John, of Halesowen, Salop, yeoman 0
3994671 2022847 2022847 defendant Gest John smith 615584 615584 Gest, John, of Halesowen, Salop, smith 0
3998013 2024048 2024048 defendant Hawkes William husbandman or yeoman 615584 615584 Hawkes, William, of Halesowen, Salop, husbandman or yeoman 0
4000036 2024778 2024778 defendant Tuckye George gent 615584 615584 Tuckye, George, of Halesowen, Salop, gent 0
4044272 2040404 2040404 defendant Hadley William yeoman 615584 615584 Hadley, William, of Halesowen, Salop, yeoman 0
4058802 2045542 2045542 defendant Roe William yeoman 615584 615584 Roe, William, of Halesowen, Salop, yeoman 1
4100815 2060607 2060607 defendant Brome alias Ac Nocke John blacksmith 615584 615584 Brome alias Ac Nocke, John, of Halesowen, Salop, blacksmith 1
4105403 2062211 2062211 defendant Robsarte Arthur gent 615584 615584 Robsarte, Arthur, of Halesowen, Salop, gent 4
4146530 2076938 2076938 defendant Grove William yeoman 615584 615584 Grove, William, of Halesowen, Salop, yeoman 0
4196643 2094371 2094371 defendant Tuckey Edward gent 615584 615584 Tuckey, Edward, of Halesowen, Salop, gent 2
4230084 2106014 2106014 defendant Muckelowe Richard yeoman 615584 615584 (Muckelowe, Richard, of Halesowen, Salop, yeoman 1
4238950 2109242 2109242 defendant Grove George yeoman 615584 615584 Grove, George, of Halesowen, Salop, or of Ludley, Worcs, yeoman 0
4260670 2116536 2116536 defendant Muckelowe Richard yeoman 615584 615584 (Muckelowe, Richard, of Halesowen, Salop, yeoman 1
4283243 2124043 2124043 defendant Gorton Richard yeoman 615584 615584 Gorton, Richard, of Halesowen, Salop, yeoman 1
4297165 2129088 2129088 defendant Theker John chapman 615584 615584 Theker, John, of Halesowen, Salop, chapman 0
4309765 2133572 2133572 defendant Bartlett William gent 615584 615584 Bartlett, William, of Halesowen, Salop, gent 0
4337475 2142843 2142843 defendant Gorton Richard yeoman 615584 615584 Gorton, Richard, of Halesowen, Salop, yeoman 2
4343916 2145154 2145154 defendant Wood George yeoman 615584 615584 Wood, George, of Halesowen, Salop, yeoman 1
4351185 2147664 2147664 defendant Whyte Thomas mercer 615584 615584 Whyte, Thomas, of Halesowen, Salop, mercer 0
4354786 2148895 2148895 defendant Partriche John nailer 615584 615584 Partriche, John, of Halesowen, Salop, nailer 0
4358903 2150349 2150349 defendant Peirshall or Peirsall Lawrence weaver 615584 615584 (Peirshall or Peirsall, Lawrence, of Halesowen, Salop, weaver 1
4376019 2156488 2156488 defendant Wight William haberdasher 615584 615584 Wight, William, of Halesowen, Salop, haberdasher 0
4378841 2157509 2157509 defendant More Thomas nailer 615584 615584 More, Thomas, of Halesowen, Salop, nailer 0
4384333 2159452 2159452 defendant Wight William haberdasher 615584 615584 Wight, William, of Halesowen, Salop, haberdasher 0
4406365 2166694 2166694 defendant Wight William haberdasher 615584 615584 Wight, William, of Halesowen, Salop, haberdasher 0
4411682 2168503 2168503 defendant Barkeley alias Manyngton William gent 615584 615584 Barkeley alias Manyngton, William, of Halesowen, Salop, gent 0
5016153 2361608 2361608 defendant Smyth Agnes widow 615584 615584 Smyth, Agnes, of Halesowen, Salop, widow 2
5029478 2365494 2365494 defendant Chiewe John chapman 615584 615584 Chiewe, John, of Halesowen, Salop, chapman 1
5215595 2420285 2420285 defendant Middelton John mercer 615584 615584 Middelton, John,of Halesowen, Salop, mercer 0
5286179 2440967 2440967 defendant Hawekys Willim barker 615584 615584 Hawekys, Willim, of Halesowen, Salop, barker 0
5343358 2458112 2458112 defendant Lynde John yeoman 615584 615584 Lynde, John, of Halesowen, Salop, yeoman 0
5523111 2512055 2512055 defendant Erdyngton Richard yeoman 615584 615584 Erdyngton, Richard, of Halesowen, Salop, yeoman 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);