names

86 rows where place_id = 590149

✎ 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
3600077 1867673 1867673 defendant Middelton Brian gent 590149 590149 Middelton, Brian, of Clifton, gent 0
3684880 1921407 1921407 defendant Savell John gent 590149 590149 Savell, John, of Clifton, gent 0
3689951 1923017 1923017 defendant Bromeham John, junior husbandman 590149 590149 Bromeham, John, junior, of Clifton, husbandman 0
3727164 1934767 1934767 defendant Drake Robert yeoman 590149 590149 Drake, Robert, of Clifton, yeoman 0
3803765 1959091 1959091 defendant Sayvell Thomas gent 590149 590149 Sayvell, Thomas, of Clifton, gent, son of Sayvell, Robert, of Halifax, gent 0
3812989 1961965 1961965 defendant Horseley Thomas husbandman 590149 590149 Horseley, Thomas, of Clifton, husbandman 0
3812990 1961965 1961965 defendant Horseley Agnes widow 590149 590149 Horseley, Agnes, of Clifton, widow 1
4045545 2040857 2040857 defendant Wylkynson Henry yeoman 590149 590149 Wylkynson, Henry, of Clifton, yeoman 0
4091717 2057327 2057327 defendant Drewe William gent 590149 590149 Drewe, William, of Clifton, gent 2
4150903 2078449 2078449 defendant Kytson John yeoman 590149 590149 Kytson, John, of Clifton, yeoman 2
4155686 2080070 2080070 defendant Kytson John husbandman 590149 590149 Kytson, John, of Clifton, husbandman 0
4155993 2080171 2080171 defendant Meade John husbandman 590149 590149 Meade, John, of Clifton, husbandman 1
4155994 2080171 2080171 defendant Underwood Lawrence laborer 590149 590149 Underwood, Lawrence, of Clifton, laborer 2
4204845 2097236 2097236 defendant Bullock John husbandman 590149 590149 Bullock, John, of Clifton, husbandman 1
4204846 2097236 2097236 defendant Drewe William laborer 590149 590149 Drewe, William, of Clifton, laborer 2
4204847 2097236 2097236 defendant Balley John, senior laborer 590149 590149 Balley, John, senior, of Clifton, laborer 3
4346093 2145887 2145887 defendant Harrison John laborer 590149 590149 Harrison, John, of Clifton, laborer 2
4365397 2152688 2152688 defendant Marticke George   590149 590149 together with Marticke, George, of Clifton, brick maker 1
4392329 2162062 2162062 defendant Martick George   590149 590149 Martick, George, of Clifton, brick maker 0
4427521 2173444 2173444 defendant Doune John de la   590149 590149 Doune, John de la, of Clifton 6
4430239 2174238 2174238 plaintiff Martel John   590149 590149 Martel, John, of Clifton, parson 2
4465544 2189893 2189893 defendant Sawer Adam   590149 590149 Sawer, Adam, of Clifton 0
4466237 2190101 2190101 defendant Taillour Ralph   590149 590149 Taillour, Ralph, of Clifton 5
4471101 2191622 2191622 defendant Hugon Simon   590149 590149 Hugon, Simon, of Clifton 0
4476406 2193286 2193286 plaintiff Fryday Thomas (legal representative) 590149 590149 Fryday, Thomas, of Clifton, parson, executors of 0
4479808 2194345 2194345 defendant Tolson Thomas   590149 590149 Tolson, Thomas, of Clifton 0
4484807 2195947 2195947 plaintiff Porter Alexander   590149 590149 Porter, Alexander, of Clifton 0
4500570 2200802 2200802 defendant Walson Thomas   590149 590149 Walson, Thomas, of Clifton 0
4501556 2201089 2201089 defendant Sclater John, junior   590149 590149 Sclater, John, junior, of Clifton, 1
4512444 2204333 2204333 defendant Henryson Thomas   590149 590149 Henryson, Thomas, of Clifton 0
4512445 2204333 2204333 defendant Stevenson John   590149 590149 Stevenson, John, of Clifton 1
4527710 2208945 2208945 defendant Walson Thomas   590149 590149 Walson, Thomas, of Clifton 3
4528472 2209185 2209185 defendant Wikynson Tolson Richard   590149 590149 Wikynson Tolson, Richard, of Clifton 0
4537987 2212161 2212161 defendant Berwyk John   590149 590149 Berwyk, John, of Clifton 0
4542341 2213497 2213497 defendant Robynson John   590149 590149 Robynson, John, of Clifton 1
4542342 2213497 2213497 defendant Stevenson John   590149 590149 Stevenson, John, of Clifton 2
4542343 2213497 2213497 defendant Tolson Thomas   590149 590149 Tolson, Thomas, of Clifton 3
4575002 2223703 2223703 defendant Pecok John   590149 590149 Pecok, John, of Clifton 0
4580538 2225401 2225401 defendant Mason John   590149 590149 Mason, John, of Clifton 3
4596184 2230060 2230060 defendant Wykynge John   590149 590149 Wykynge, John, of Clifton 2
4598827 2230860 2230860 defendant Carter William   590149 590149 Carter, William, of Clifton 2
4598834 2230860 2230860 defendant Leche John   590149 590149 Leche, John, of Clifton 9
4598852 2230865 2230865 defendant Leche John   590149 590149 Leche, John, of Clifton 6
4598855 2230865 2230865 defendant Carter William   590149 590149 Carter, William, of Clifton 9
4603180 2232203 2232203 plaintiff Williamson John   590149 590149 Williamson, John, of Clifton 0
4610491 2234353 2234353 plaintiff Carter Thomas   590149 590149 Carter, Thomas, of Clifton 0
4615081 2235728 2235728 defendant Bedford John   590149 590149 Bedford, John, of Clifton 0
4639906 2243178 2243178 defendant Personson William   590149 590149 Personson, William, of Clifton 0
4639907 2243178 2243178 defendant Personson John   590149 590149 Personson, John, of Clifton 1
4639909 2243178 2243178 defendant Scot William   590149 590149 Scot, William, of Clifton 3
4659539 2248835 2248835 defendant Scot William husbandman 590149 590149 Scot, William, of Clifton, husbandman 0
4659873 2248942 2248942 defendant Personson John husbandman 590149 590149 Personson, John, of Clifton, husbandman 0
4659874 2248942 2248942 defendant Personson William husbandman 590149 590149 Personson, William, of Clifton, husbandman 1
4659877 2248943 2248943 defendant Scotte William husbandman 590149 590149 Scotte, William, of Clifton, husbandman 1
4659882 2248944 2248944 defendant Scotte William husbandman 590149 590149 Scotte, William, of Clifton, husbandman 1
4687200 2261603 2261603 defendant Jones-servant Stanford Agnes laborer 590149 590149 Jones-servant Stanford, Agnes, of Clifton, laborer 1
4696231 2264305 2264305 defendant Steveneson Thomas husbandman 590149 590149 Steveneson, Thomas, of Clifton, husbandman 1
4696233 2264305 2264305 defendant Marschall John, sen husbandman 590149 590149 Marschall, John, sen, of Clifton, husbandman 3
4697296 2264635 2264635 defendant Genne William yeoman 590149 590149 Genne, William, of Clifton, yeoman 1
4711401 2268897 2268897 defendant Atkynson John yeoman 590149 590149 Atkynson, John, of Clifton, yeoman 0
4711406 2268897 2268897 defendant Hochynson John yeoman 590149 590149 Hochynson, John, of Clifton, yeoman 5
4711407 2268897 2268897 defendant Rychartson John husbandman 590149 590149 Rychartson, John, of Clifton, husbandman 6
4711409 2268897 2268897 defendant Jonesson John husbandman 590149 590149 together with Jonesson, John, of Clifton, husbandman 8
4714384 2269828 2269828 defendant Stevenesson Thomas husbandman 590149 590149 Stevenesson, Thomas, of Clifton, husbandman 2
4720061 2271623 2271623 defendant Carter John loader 590149 590149 Carter, John, of Clifton, loader 0
4746758 2279549 2279549 defendant Wright Nicholas carpetner 590149 590149 Wright, Nicholas, of Clifton, carpetner 0
4751783 2281013 2281013 plaintiff Stalworthman William   590149 590149 Stalworthman, William, of Clifton, vicar 0
4846604 2310449 2310449 defendant Barowe John fishmonger 590149 590149 Barowe, John, of Clifton, fishmonger 0
4852968 2312349 2312349 defendant Straunge Nicholas husbandman 590149 590149 Straunge, Nicholas, of Clifton, husbandman 0
4856137 2313291 2313291 plaintiff Banester Roger   590149 590149 Banester, Roger, of Clifton 0
4856194 2313312 2313312 defendant Yowehirde Adam husbandman 590149 590149 Yowehirde, Adam, of Clifton, husbandman 2
4913186 2330621 2330621 defendant atte Wode John husbandman 590149 590149 atte Wode, John, of Clifton, husbandman 0
4949009 2341677 2341677 defendant Burdeux William husbandman 590149 590149 Burdeux, William, of Clifton, husbandman 4
4956735 2343969 2343969 plaintiff Vyncent Roger   590149 590149 Vyncent, Roger, of Clifton 0
5054557 2372935 2372935 defendant Ketilbrigge Owen husbandman 590149 590149 Ketilbrigge, Owen, of Clifton, husbandman 0
5151330 2401539 2401539 defendant Berney John husbandman 590149 590149 Berney, John, of Clifton, husbandman 0
5160821 2404260 2404260 defendant Farmour Thomas husbandman 590149 590149 Farmour, Thomas, of Clifton, husbandman 2
5391676 2472690 2472690 defendant Yong Joan widow 590149 590149 Yong, Joan, of Clifton by Dorchester, widow 0
5391677 2472690 2472690 defendant Hopkyns John husbandman 590149 590149 Hopkyns, John, of Clifton by Dorchester, husbandman 1
5601539 2535373 2535373 defendant Butler Richard husbandman 590149 590149 Butler, Richard, of Clifton, husbandman 0
5631402 2553825 2553825 defendant Rande William yeoman 590149 590149 Rande, William, of Clifton, yeoman 0
5631403 2553825 2553825 defendant Dynewele Hugh yeoman 590149 590149 Dynewele, Hugh, of Clifton, yeoman 1
5631404 2553825 2553825 defendant Bramtwayt Thomas yeoman 590149 590149 Bramtwayt, Thomas, of Clifton, yeoman 2
5631406 2553825 2553825 defendant Bramtwayt John yeoman 590149 590149 Bramtwayt, John, of Clifton, yeoman 4
5631407 2553825 2553825 defendant Bramtwayt Richard yeoman 590149 590149 Bramtwayt, Richard, of Clifton, yeoman 5
5631408 2553825 2553825 defendant Clifton Thomas yeoman 590149 590149 Clifton, Thomas, of Clifton, yeoman 6

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