names

91 rows where place_id = 589300

✎ 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
3597148 1866731 1866731 defendant Snoth or South Arnold husbandman 589300 589300 Snoth or South, Arnold, of Tonge, husbandman 3
3599749 1867565 1867565 defendant Wylkyn John yeoman 589300 589300 Wylkyn, John, of Tonge, yeoman 0
3630951 1904501 1904501 defendant Cortfeld John husbandman 589300 589300 Cortfeld, John, of Tonge, husbandman 0
3637408 1906505 1906505 defendant Forste John husbandman 589300 589300 Forste, John, of Tonge, husbandman 1
3650901 1910649 1910649 defendant Mirfeld Peter esq 589300 589300 Mirfeld, Peter, of Tonge, esq 0
3651849 1910934 1910934 defendant Goldesburgh Thomas husbandman 589300 589300 Goldesburgh, Thomas, of Tonge, husbandman 0
3695331 1924764 1924764 defendant Wilkyn David yeoman of the crown 589300 589300 Wilkyn, David, of Tonge, yeoman of the crown 0
3742272 1939454 1939454 defendant Broke John chaplain 589300 589300 Broke, John, of Tonge, chaplain 0
3797710 1957181 1957181 defendant Mirfelde Peter esq 589300 589300 Mirfelde, Peter, of Tonge, esq 2
3951970 2007752 2007752 plaintiff Harryson Richard husbandman 589300 589300 Harryson, Richard, of Tonge, husbandman 0
3990223 2021258 2021258 plaintiff Bentley William gent 589300 589300 Bentley, William, of Tonge, gent 0
3990226 2021259 2021259 plaintiff Bentley William gent 589300 589300 Bentley, William, of Tonge, gent 0
3990229 2021260 2021260 plaintiff Bentley William gent 589300 589300 Bentley, William, of Tonge, gent 0
3993950 2022586 2022586 defendant Burforde Thomas glover 589300 589300 Burforde, Thomas, of Tonge, glover 2
4008857 2027932 2027932 defendant Tempest Henry esq 589300 589300 Tempest, Henry, of Tonge, esq 0
4009194 2028058 2028058 defendant Dawson Richard yeoman 589300 589300 Dawson, Richard, of Tonge, yeoman 0
4009195 2028058 2028058 defendant Sharpe John yeoman 589300 589300 Sharpe, John, of Tonge, yeoman 1
4009196 2028058 2028058 defendant Stede Robert yeoman 589300 589300 Stede, Robert, of Tonge, yeoman 2
4009197 2028058 2028058 defendant Byrkbye Thomas yeoman 589300 589300 Byrkbye, Thomas, of Tonge, yeoman 3
4052033 2043152 2043152 defendant Bentley William gent 589300 589300 Bentley, William, of Tonge, gent 0
4052037 2043153 2043153 defendant Bentley William gent 589300 589300 Bentley, William, of Tonge, gent 0
4060666 2046217 2046217 defendant Hylton Henry husbandman 589300 589300 Hylton, Henry, of Tonge, or of Midleton, Lancs, husbandman 0
4098747 2059884 2059884 defendant Forster Thomas gent 589300 589300 Forster, Thomas, of Tonge, or of Morton, gent 0
4098748 2059884 2059884 defendant Agarde Thomas gent 589300 589300 Agarde, Thomas, of Tonge, gent 1
4106372 2062570 2062570 plaintiff Lyptrote Peter laborer 589300 589300 Lyptrote, Peter, of Tonge, laborer 1
4122621 2068385 2068385 defendant Benteley William gent 589300 589300 Benteley, William, of Tonge, gent 0
4145473 2076574 2076574 defendant Rudge William clerk 589300 589300 Rudge, William, of Tonge, clerk 1
4162024 2082274 2082274 defendant Broke alias Silkeman Thomas husbandman 589300 589300 Broke alias Silkeman, Thomas, of Tonge, husbandman 0
4172938 2085987 2085987 defendant Tempest Walter gent 589300 589300 Tempest, Walter, of Tonge, gent 3
4231573 2106542 2106542 defendant Durborne Leonard husbandman 589300 589300 Durborne, Leonard, of Tonge, husbandman 0
4310060 2133676 2133676 defendant Lyndley Francis gent 589300 589300 Lyndley, Francis, of Tonge, gent 1
4321169 2137498 2137498 defendant Atkinson Thomas cooper 589300 589300 Atkinson, Thomas, of Tonge, cooper 0
4354953 2148949 2148949 defendant Poole Reginald smith 589300 589300 Poole, Reginald, of Tonge, smith 1
4362661 2151704 2151704 defendant Dunthorpe Richard husbandman 589300 589300 Dunthorpe, Richard, of Tonge, or of Breton, husbandman 1
4423442 2172183 2172183 defendant Hunte William le   589300 589300 Hunte, William le, of Tonge 0
4457322 2187304 2187304 defendant Wryght Richard   589300 589300 Wryght, Richard, of Tonge 0
4511628 2204089 2204089 defendant Coupere John   589300 589300 Coupere, John, of Tonge 2
4516670 2205627 2205627 plaintiff Cook Thomas   589300 589300 Cook, Thomas, of Tonge 0
4526644 2208613 2208613 defendant Wildemir John   589300 589300 Wildemir, John, of Tonge 0
4558523 2218616 2218616 defendant Gyner Thomas   589300 589300 Gyner, Thomas, of Tonge 0
4560559 2219241 2219241 defendant Smytheot Lawrence   589300 589300 Smytheot, Lawrence, of Tonge 0
4566108 2220959 2220959 defendant Seman Henry   589300 589300 Seman, Henry, of Tonge 0
4629845 2240258 2240258 defendant atte Forthe Stephen   589300 589300 atte Forthe, Stephen, of Tonge 0
4643259 2244136 2244136 defendant Bak Richard   589300 589300 Bak, Richard, of Tonge 4
4643260 2244136 2244136 defendant Forthe Stephen   589300 589300 Forthe, Stephen, of Tonge 5
4662256 2249668 2249668 defendant Huchon John   589300 589300 Huchon, John, of Tonge, holy water clerk 0
4662257 2249668 2249668 defendant Faceby Thomas courser 589300 589300 Faceby, Thomas, of Tonge, courser 1
4734671 2275999 2275999 defendant Hayt John   589300 589300 Hayt, John, of Tonge, boat man 0
4754917 2281918 2281918 defendant Clerk John husbandman 589300 589300 Clerk, John, of Tonge, husbandman 0
4754921 2281920 2281920 defendant Clerk John husbandman 589300 589300 Clerk, John, of Tonge, husbandman 0
4756926 2282533 2282533 defendant Temple John husbandman 589300 589300 Temple, John, of Tonge, husbandman 0
4773893 2287814 2287814 plaintiff Tonge John   589300 589300 Tonge, John, of Tonge 0
4799325 2295965 2295965 plaintiff Tonge John   589300 589300 Tonge, John, of Tonge 0
4815593 2300983 2300983 defendant Wryght Richard husbandman 589300 589300 Wryght, Richard, of Tonge, husbandman 6
4844799 2309895 2309895 defendant Bryson Robert husbandman 589300 589300 Bryson, Robert, of Tonge, husbandman 1
4963992 2346140 2346140 defendant Hynam John husbandman 589300 589300 Hynam, John, of Tonge, husbandman 0
5052967 2372479 2372479 defendant Garnet Thomas yeoman 589300 589300 Garnet, Thomas, of Tonge, yeoman 0
5084099 2381746 2381746 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5098481 2385987 2385987 defendant Woden Adomar laborer 589300 589300 Woden, Adomar, of Tonge, laborer 0
5098483 2385987 2385987 defendant Blaket Henry husbandman 589300 589300 Blaket, Henry, of Tonge, husbandman 2
5098485 2385987 2385987 defendant Boole William laborer 589300 589300 Boole, William, of Tonge, laborer 4
5109110 2389088 2389088 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5131062 2395571 2395571 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5134253 2396514 2396514 defendant Ive Nicholas husbandman 589300 589300 Ive, Nicholas, of Tonge, husbandman 1
5150569 2401308 2401308 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5166188 2405838 2405838 defendant Byrche John carpenter 589300 589300 Byrche, John, of Tonge, carpenter 0
5185457 2411492 2411492 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5204789 2417148 2417148 defendant Wade Stephen yeoman 589300 589300 Wade, Stephen, of Tonge, yeoman 0
5246718 2429202 2429202 defendant Castell Robert husbandman 589300 589300 Castell, Robert, of Tonge, husbandman 0
5254625 2431567 2431567 defendant Hewe John husbandman 589300 589300 Hewe, John, of Tonge, husbandman 1
5255886 2431961 2431961 defendant Tenacre John laborer 589300 589300 Tenacre, John, of Tonge, husbandman, or of Tunstall, laborer 0
5255891 2431963 2431963 defendant Cryspe Walter husbandman 589300 589300 Cryspe, Walter, of Tonge, husbandman 1
5332968 2454927 2454927 defendant Castell Robert husbandman 589300 589300 Castell, Robert, of Tonge, husbandman 0
5332970 2454928 2454928 defendant Castell Robert husbandman 589300 589300 Castell, Robert, of Tonge, husbandman 0
5334391 2455356 2455356 defendant Castell Robert husbandman 589300 589300 Castell, Robert, of Tonge, husbandman 3
5340279 2457167 2457167 defendant Wylkyn John husbandman 589300 589300 Wylkyn, John, of Tonge, husbandman 0
5366643 2465218 2465218 defendant Wylkyn John yeoman 589300 589300 Wylkyn, John, of Tonge, yeoman 0
5390384 2472313 2472313 defendant Wade John   589300 589300 Wade, John, of Tonge, husbandman, son of Thomas 0
5403906 2476190 2476190 defendant Marchall John husbandman 589300 589300 Marchall, John, of Tonge, husbandman 0
5417017 2480002 2480002 defendant Marshall Thomas husbandman 589300 589300 Marshall, Thomas, of Tonge, husbandman 0
5434118 2485159 2485159 defendant Marshall Thomas husbandman 589300 589300 Marshall, Thomas, of Tonge, husbandman 0
5434120 2485160 2485160 defendant Marshall Thomas husbandman 589300 589300 Marshall, Thomas, of Tonge, husbandman 0
5434122 2485161 2485161 defendant Marshall Thomas husbandman 589300 589300 Marshall, Thomas, of Tonge, husbandman 0
5481743 2499472 2499472 defendant Rolf John husbandman 589300 589300 Rolf, John, of Tonge, husbandman 1
5498403 2504482 2504482 defendant Marshall Thomas husbandman 589300 589300 Marshall, Thomas, of Tonge, husbandman 0
5528445 2513431 2513431 defendant Fatreclough Gilbert cordwainer 589300 589300 Fatreclough, Gilbert, of Tonge, cordwainer 4
5537594 2516247 2516247 defendant Bunce John husbandman 589300 589300 Bunce, John, of Tonge, husbandman 0
5601651 2535413 2535413 defendant Mynsterley Hugh clerk 589300 589300 Mynsterley, Hugh, of Tonge, clerk 0
5601652 2535413 2535413 defendant Alcok Ralph clerk 589300 589300 Alcok, Ralph, of Tonge, clerk 1
5601653 2535413 2535413 defendant Clerk William clerk 589300 589300 Clerk, William, of Tonge, clerk 2
5633624 2554514 2554514 defendant Laund John   589300 589300 Laund, John, of Tonge, "soynour" 1

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);