names

91 rows where place_id = 592735

✎ 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
3608699 1870381 1870381 defendant Taillour Thomas merchant 592735 592735 Taillour, Thomas, of Everton, merchant 0
3610715 1871015 1871015 defendant A Bagney Robert yeoman 592735 592735 A Bagney, Robert, of Everton, yeoman 0
3632896 1905105 1905105 defendant Lane Thomas husbandman 592735 592735 Lane, Thomas, of Everton, husbandman 4
3632902 1905106 1905106 defendant Lane Thomas husbandman 592735 592735 Lane, Thomas, of Everton, husbandman 4
3685821 1921722 1921722 defendant Newenham Edmund esq 592735 592735 Newenham, Edmund, of Everton, esq 0
3688526 1922570 1922570 defendant Lane William husbandman 592735 592735 Lane, William, of Everton, husbandman 0
3700798 1926501 1926501 defendant Newenham Edmund esq 592735 592735 Newenham, Edmund, of Everton, esq 0
3741731 1939276 1939276 defendant Markham Robert husbandman 592735 592735 Markham, Robert, of Everton, husbandman 5
3781498 1951953 1951953 plaintiff Harmar Edmund husbandman 592735 592735 Harmar, Edmund, of Everton, husbandman 0
3791970 1955338 1955338 plaintiff Andrewes Richard   592735 592735 Andrewes, Richard, of Everton 0
3795398 1956432 1956432 defendant Twell Thomas yeoman 592735 592735 Twell, Thomas, of Everton, yeoman 0
3821800 1964706 1964706 defendant Bukkyngham John husbandman 592735 592735 Bukkyngham, John, of Everton, husbandman 0
3833155 1968299 1968299 defendant Holtam Richard husbandman 592735 592735 Holtam, Richard, of Everton, husbandman 0
3833157 1968300 1968300 defendant Holtam Richard husbandman 592735 592735 Holtam, Richard, of Everton, husbandman 0
3848944 1973264 1973264 defendant Holtam Richard husbandman 592735 592735 Holtam, Richard, of Everton, husbandman 0
3864163 1978203 1978203 defendant Holtam Richard husbandman 592735 592735 Holtam, Richard, of Everton, husbandman 0
3885580 1985430 1985430 plaintiff Bendowe Edward gent 592735 592735 Bendowe, Edward, of Everton, gent 0
3894584 1988398 1988398 defendant Kapas Thomas husbandman 592735 592735 Kapas, Thomas, of Everton, husbandman 1
3919971 1997019 1997019 defendant Busbye Edward yeoman 592735 592735 Busbye, Edward, of Everton, yeoman 0
3919972 1997019 1997019 defendant Kepaxe Thomas husbandman 592735 592735 Kepaxe, Thomas, of Everton, husbandman 1
3919973 1997019 1997019 defendant Hollyngworthe William husbandman 592735 592735 Hollyngworthe, William, of Everton, husbandman 2
3997097 2023730 2023730 defendant West Richard husbandman 592735 592735 West, Richard, of Everton, husbandman 0
3997098 2023730 2023730 defendant Rychardson George husbandman 592735 592735 Rychardson, George, of Everton, husbandman 1
4013327 2029499 2029499 defendant Harryson Thomas yeoman 592735 592735 Harryson, Thomas, of Everton, yeoman 0
4013329 2029500 2029500 defendant Harryson Thomas yeoman 592735 592735 Harryson, Thomas, of Everton, yeoman 0
4013331 2029501 2029501 defendant Harryson Thomas yeoman 592735 592735 Harryson, Thomas, of Everton, yeoman 0
4013333 2029502 2029502 defendant Smythe John husbandman 592735 592735 Smythe, John, of Everton, husbandman 0
4100932 2060648 2060648 defendant Vawter John gent 592735 592735 Vawter, John, of Everton, gent 1
4109596 2063691 2063691 defendant Wharton Edward yeoman 592735 592735 Wharton, Edward, of Everton, yeoman 0
4297825 2129327 2129327 defendant Rogers Hugh gent 592735 592735 Rogers, Hugh, of Everton, gent 3
4327157 2139411 2139411 defendant Wall Thomas butcher 592735 592735 Wall, Thomas, of Everton, butcher 2
4364747 2152445 2152445 defendant Godley John laborer 592735 592735 Godley, John, of Everton, laborer 3
4396540 2163415 2163415 defendant Furbisher John gent 592735 592735 Furbisher, John, of Everton, gent 1
4447100 2184003 2184003 defendant Baker Henry   592735 592735 Baker, Henry, of Everton 0
4517197 2205777 2205777 defendant Killif Thomas   592735 592735 Killif, Thomas, of Everton 0
4551204 2216319 2216319 defendant Weston Walter   592735 592735 Weston, Walter, of Everton 1
4562227 2219754 2219754 defendant Prentys John   592735 592735 Prentys, John, of Everton 2
4562228 2219754 2219754 defendant Weston Walter   592735 592735 Weston, Walter, of Everton 3
4599840 2231178 2231178 defendant Cok Peter   592735 592735 Cok, Peter, of Everton 0
4602377 2231960 2231960 defendant Fisshe John   592735 592735 Fisshe, John, of Everton 0
4602384 2231961 2231961 defendant Fissher John   592735 592735 Fissher, John, of Everton 0
4617039 2236338 2236338 defendant Lammare William   592735 592735 Lammare, William, of Everton 2
4630339 2240397 2240397 defendant Squyer John   592735 592735 Squyer, John, of Everton 3
4659121 2248725 2248725 defendant Gautford Richard gent 592735 592735 Gautford, Richard, of Everton, gent 1
4669186 2256068 2256068 defendant Marys John husbandman 592735 592735 Marys, John, of Everton, husbandman 1
4673576 2257367 2257367 defendant Gaitford John esq 592735 592735 Gaitford, John, of Everton, esq 0
4673577 2257367 2257367 defendant Gaitford Richard gent 592735 592735 Gaitford, Richard, of Everton, gent 1
4712269 2269152 2269152 defendant Shirburne John husbandman 592735 592735 Shirburne, John, of Everton, husbandman 3
4724818 2273059 2273059 defendant Shirburn John husbandman 592735 592735 Shirburn, John, of Everton, husbandman 2
4729347 2274397 2274397 defendant Ware John, sen husbandman 592735 592735 Ware, John, sen, of Everton, husbandman 0
4730269 2274671 2274671 defendant Preston John yeoman 592735 592735 Preston, John, of Everton, yeoman 3
4764623 2284921 2284921 defendant Weston John carpenter 592735 592735 Weston, John, of Everton, carpenter 4
4774805 2288113 2288113 defendant Pokok William husbandman 592735 592735 Pokok, William, of Everton, husbandman 0
4776897 2288762 2288762 defendant Tyrold Richard gent 592735 592735 Tyrold, Richard, of Everton, gent 0
4786664 2291883 2291883 defendant Pecok William husbandman 592735 592735 Pecok, William, of Everton, husbandman 0
4790243 2293031 2293031 defendant de Gaytford Richard esq 592735 592735 de Gaytford, Richard, of Everton, esq 0
4834934 2306928 2306928 defendant Chambur Thomas husbandman 592735 592735 Chambur, Thomas, of Everton, husbandman 2
4870511 2317750 2317750 defendant Gunthorp John yeoman 592735 592735 Gunthorp, John, of Everton, yeoman 0
4870512 2317750 2317750 defendant Shirburn John husbandman 592735 592735 Shirburn, John, of Everton, husbandman 1
4871261 2317983 2317983 defendant Gree John husbandman 592735 592735 Gree, John, of Everton, husbandman 3
4874517 2318973 2318973 defendant Plummer John plumber 592735 592735 Plummer, John, of Everton, plumber 2
4874553 2318986 2318986 defendant Chaumber Thomas yeoman 592735 592735 Chaumber, Thomas, of Everton, yeoman 0
4901861 2327190 2327190 defendant Chambre Thomas yeoman 592735 592735 Chambre, Thomas, of Everton, yeoman 0
4994960 2355352 2355352 defendant Stondon Walter husbandman 592735 592735 Stondon, Walter, of Everton, husbandman 0
4994961 2355352 2355352 defendant Rogger Robert husbandman 592735 592735 Rogger, Robert, of Everton, husbandman 1
4994962 2355352 2355352 defendant Smyth Henry husbandman 592735 592735 Smyth, Henry, of Everton, husbandman 2
4994963 2355352 2355352 defendant Burley Robert husbandman 592735 592735 Burley, Robert, of Everton, husbandman 3
4994964 2355352 2355352 defendant Torold John husbandman 592735 592735 Torold, John, of Everton, husbandman 4
5023032 2363645 2363645 defendant Colyn Richard husbandman 592735 592735 Colyn, Richard, of Everton, husbandman 0
5024725 2364152 2364152 defendant Fournes John husbandman 592735 592735 Fournes, John, of Everton, husbandman 3
5031806 2366173 2366173 defendant Stephyns William husbandman 592735 592735 Stephyns, William, of Everton, husbandman 0
5043577 2369699 2369699 defendant Malpas William husbandman 592735 592735 Malpas, William, of Everton, husbandman 0
5073943 2378693 2378693 defendant Colyn John husbandman 592735 592735 Colyn, John, of Everton, husbandman 3
5074067 2378735 2378735 defendant West John husbandman 592735 592735 West, John, of Everton, husbandman 0
5232244 2425008 2425008 defendant Cranwell John, senior husbandman 592735 592735 Cranwell, John, senior, of Everton, husbandman 0
5232245 2425008 2425008 defendant Cranwell Henry husbandman 592735 592735 Cranwell, Henry, of Everton, husbandman 1
5232246 2425008 2425008 defendant Smyth Thomas husbandman 592735 592735 Smyth, Thomas, of Everton, husbandman 2
5239095 2427026 2427026 defendant atte Welle William husbandman 592735 592735 atte Welle, William, of Everton, husbandman 4
5265610 2434998 2434998 defendant Cramwell Henry potter 592735 592735 together with Cramwell, Henry, of Everton, potter 1
5265612 2434998 2434998 defendant Preston John husbandman 592735 592735 Preston, John, of Everton, husbandman 3
5265619 2434999 2434999 defendant Newman Benedict chaplain 592735 592735 Newman, Benedict, of Everton, chaplain 3
5265620 2434999 2434999 defendant Cramwell Henry potter 592735 592735 Cramwell, Henry, of Everton, potter 4
5265621 2434999 2434999 defendant Preston John husbandman 592735 592735 Preston, John, of Everton, husbandman 5
5354471 2461470 2461470 defendant at Welle William husbandman 592735 592735 at Welle, William, of Everton, husbandman 1
5356812 2462196 2462196 defendant Chepyngale Robert husbandman 592735 592735 Chepyngale, Robert, of Everton, husbandman 1
5356815 2462196 2462196 defendant Rodes Nicholas husbandman 592735 592735 Rodes, Nicholas, of Everton, husbandman 4
5361989 2463776 2463776 plaintiff Tanfeld Robert esq 592735 592735 Tanfeld, Robert, of Everton, esq 0
5564183 2524136 2524136 defendant Tegge Geoffrey clerk 592735 592735 Tegge, Geoffrey, of Everton, clerk 0
5591391 2532280 2532280 defendant Rogers Ralph husbandman 592735 592735 Rogers, Ralph, of Everton, husbandman 4
5621879 2550753 2550753 plaintiff Thoresby Ellis de   592735 592735 Thoresby, Ellis de, of Everton 0
5630277 2553476 2553476 defendant Gaytford Joan widow 592735 592735 Gaytford, Joan, of Everton, widow 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);