names

56 rows where place_id = 755254

✎ 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
4263961 2117605 2117605 defendant Litleton Edward   755254 755254 Litleton, Edward, of Staffordshire, knight 0
4426830 2173210 2173210 defendant Griffith Ralph ap   755254 755254 Griffith, Ralph ap, of Staffordshire 0
4435732 2175920 2175920 defendant Bradeleye John   755254 755254 Bradeleye, John, of Staffordshire 1
4435970 2175986 2175986 defendant Bradeley John   755254 755254 Bradeley, John, of Staffordshire 1
4442700 2182667 2182667 defendant Perton John de   755254 755254 Perton, John de, of Staffordshire, formerly sheriff 0
4470459 2191406 2191406 defendant Bagot John butcher 755254 755254 Bagot, John, of Staffordshire, butcher 0
4478083 2193818 2193818 defendant Frisby John   755254 755254 Frisby, John, of Staffordshire 0
4487793 2196897 2196897 defendant Newenton John esq 755254 755254 Newenton, John, of Staffordshire, esq 1
4501893 2201192 2201192 defendant Newenton John   755254 755254 Newenton, John, of Staffordshire, esq, living with William Beauchamp, knight 1
4509449 2203425 2203425 defendant Walshale John esq 755254 755254 Walshale, John, of Staffordshire, esq 1
4509460 2203426 2203426 defendant Walshale John esq 755254 755254 Walshale, John, of Staffordshire, esq 1
4524457 2207989 2207989 defendant Langford Hugh   755254 755254 Langford, Hugh, of Staffordshire 0
4544224 2214112 2214112 defendant Barbour Henry   755254 755254 Barbour, Henry, of Staffordshire 1
4552864 2216838 2216838 defendant Harpeden John esq 755254 755254 Harpeden, John, of Staffordshire, esq 3
4553201 2216935 2216935 defendant Swynarton Thomas esq 755254 755254 Swynarton, Thomas, of Staffordshire, esq 0
4555048 2217506 2217506 defendant Swynson atte Walle Robert   755254 755254 Swynson atte Walle, Robert, of Staffordshire 0
4557971 2218426 2218426 defendant Griffith Thomas   755254 755254 Griffith, Thomas, of Staffordshire 1
4558638 2218655 2218655 plaintiff Bedulf John   755254 755254 Bedulf, John, of Staffordshire 1
4573520 2223243 2223243 defendant Hampton John esq 755254 755254 Hampton, John, of Staffordshire, esq 5
4582588 2225994 2225994 defendant Thiknes Thomas   755254 755254 Thiknes, Thomas, of Staffordshire 3
4586246 2227119 2227119 defendant Huwet John   755254 755254 Huwet, John, of Staffordshire 6
4586255 2227120 2227120 defendant Huwet John   755254 755254 Huwet, John, of Staffordshire 6
4586407 2227163 2227163 defendant Horsley Richard goldsmith 755254 755254 Horsley, Richard, of Staffordshire, goldsmith 0
4588741 2227859 2227859 defendant Swynerton Thomas esq 755254 755254 Swynerton, Thomas, of Staffordshire, esq 0
4589210 2228007 2228007 defendant Thikenes Thomas de   755254 755254 Thikenes, Thomas de, of Staffordshire 0
4592049 2228867 2228867 defendant Stanford Hugh de   755254 755254 Stanford, Hugh de, of Staffordshire 0
4608349 2233723 2233723 defendant Swynarton Thomas esq 755254 755254 Swynarton, Thomas, of Staffordshire, esq 0
4608381 2233732 2233732 defendant Swynarton Thomas esq 755254 755254 Swynarton, Thomas, of Staffordshire, esq 0
4608447 2233749 2233749 defendant Delves John   755254 755254 Delves, John, of Staffordshire, esquire 4
4609704 2234130 2234130 defendant Stubberd John   755254 755254 Stubberd, John, of Staffordshire 3
4614936 2235683 2235683 defendant Delves John   755254 755254 Delves, John, of Staffordshire 0
4614937 2235683 2235683 defendant Thekneys Thomas   755254 755254 Thekneys, Thomas, of Staffordshire 1
4615593 2235877 2235877 defendant Delves John esq 755254 755254 Delves, John, of Staffordshire, esq 0
4624110 2238519 2238519 defendant Coton Thomas   755254 755254 Coton, Thomas, of Staffordshire 2
4625040 2238795 2238795 defendant Hethe John   755254 755254 Hethe, John, of Staffordshire 4
4631157 2240643 2240643 defendant Watford Nicholas   755254 755254 Watford, Nicholas, of Staffordshire 4
4640204 2243248 2243248 defendant Renacres Richard   755254 755254 Renacres, Richard, of Staffordshire 0
4643994 2244342 2244342 defendant Pare John   755254 755254 Pare, John, of Staffordshire 2
4647169 2245222 2245222 defendant Aspley Thomas   755254 755254 Aspley, Thomas, of Staffordshire 0
4719254 2271368 2271368 defendant Swynarton Thomas gent 755254 755254 Swynarton, Thomas, of Staffordshire, gent 0
4746083 2279353 2279353 plaintiff Haluton Humphrey esq 755254 755254 Haluton, Humphrey, of Staffordshire, esq 0
4752192 2281115 2281115 defendant Cawardyn David esq 755254 755254 Cawardyn, David, of Staffordshire, esq 0
4771507 2287071 2287071 plaintiff Seche Thomas de   755254 755254 Seche, Thomas de, of Staffordshire 0
4916032 2331516 2331516 plaintiff Egerton Ralph esq & sheriff 755254 755254 Egerton, Ralph, of Staffordshire, esq & sheriff 0
4916035 2331517 2331517 plaintiff Egerton Ralph esq & sheriff 755254 755254 Egerton, Ralph, of Staffordshire, esq & sheriff, on his own account 0
5275170 2437813 2437813 defendant Fawne Henry chapman 755254 755254 Fawne, Henry, of Staffordshire, chapman 2
5311119 2448356 2448356 defendant Auncell John dyer 755254 755254 Auncell, John, of Staffordshire, dyer 0
5400802 2475293 2475293 defendant Steward John laborer 755254 755254 Steward, John, of Staffordshire, laborer 0
5408382 2477477 2477477 defendant Swynerton Elizabeth widow 755254 755254 Swynerton, Elizabeth, of Staffordshire, widow 0
5415366 2479530 2479530 defendant Kempe William husbandman 755254 755254 Kempe, William, of Staffordshire, husbandman 3
5442683 2487725 2487725 defendant Hopkynson Thomas husbandman 755254 755254 Hopkynson, Thomas, of Staffordshire, husbandman 1
5611527 2547336 2547336 defendant Basset Ralph   755254 755254 Basset, Ralph, of Staffordshire 6
5612156 2547538 2547538 defendant Perdon John de   755254 755254 Perdon, John de, of Staffordshire, formerly sheriff 0
5613811 2548093 2548093 defendant del Hull Thomas   755254 755254 del Hull, Thomas, of Staffordshire 3
5616325 2548900 2548900 defendant Kynges William   755254 755254 Kynges, William, of Staffordshire 3
5618255 2549526 2549526 defendant Sharsshull William   755254 755254 Sharsshull, William, of Staffordshire 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);