names

72 rows where place_id = 594496

✎ 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
3616348 1872753 1872753 defendant Woley William yeoman 594496 594496 Woley, William, of Warsop, yeoman 0
3616349 1872753 1872753 defendant Wordesworth Richard laborer 594496 594496 Wordesworth, Richard, of Warsop, laborer 1
3695169 1924711 1924711 defendant Barker Simon husbandman 594496 594496 Barker, Simon, of Warsop, husbandman 0
3695170 1924711 1924711 defendant Richardson George   594496 594496 Richardson, George, of Warsop 1
3695172 1924712 1924712 defendant Pye John (legal representative) 594496 594496 Pye, John, of Warsop, executors of 0
3695173 1924712 1924712 defendant Barker Simon husbandman 594496 594496 (Barker, Simon, of Warsop, husbandman 1
3695174 1924712 1924712 defendant Richardson George husbandman 594496 594496 Richardson, George, of Warsop, husbandman 2
3704277 1927636 1927636 defendant Hunt Richard husbandman 594496 594496 Hunt, Richard, of Warsop, husbandman 0
3726759 1934635 1934635 defendant Hunt Richard carpenter 594496 594496 Hunt, Richard, of Warsop, carpenter 1
3779492 1951308 1951308 defendant Hunt Thomas carpenter 594496 594496 Hunt, Thomas, of Warsop, carpenter 0
3828759 1966870 1966870 defendant Kestell Robert husbandman 594496 594496 Kestell, Robert, of Warsop, husbandman 0
3828760 1966870 1966870 defendant Smyth Nicholas husbandman 594496 594496 Smyth, Nicholas, of Warsop, husbandman 1
3919334 1996796 1996796 defendant Stryngfelowe Ralph shoemaker 594496 594496 Stryngfelowe, Ralph, of Warsop, shoemaker 0
4492744 2198430 2198430 defendant Galdale Thomas chaplain 594496 594496 Galdale, Thomas, of Warsop, chaplain 0
4540309 2212865 2212865 defendant Payn John   594496 594496 Payn, John, of Warsop 2
4567345 2221343 2221343 defendant Westmerland William de   594496 594496 Westmerland, William de, of Warsop 1
4588912 2227906 2227906 defendant Benson John   594496 594496 Benson, John, of Warsop 0
4596169 2230055 2230055 defendant Halum John   594496 594496 Halum, John, of Warsop 0
4596170 2230055 2230055 defendant Grice Nicholas   594496 594496 Grice, Nicholas, of Warsop 1
4602509 2232002 2232002 defendant Roudon William   594496 594496 Roudon, William, of Warsop, parson 5
4627715 2239598 2239598 plaintiff Roudon William de   594496 594496 Roudon, William de, of Warsop, parson 0
4627721 2239598 2239598 defendant Lokwode John   594496 594496 Lokwode, John, of Warsop 5
4627722 2239599 2239599 plaintiff Roudon William de   594496 594496 Roudon, William de, of Warsop, parson 0
4627723 2239599 2239599 defendant Rasche Richard   594496 594496 Rasche, Richard, of Warsop 0
4627724 2239600 2239600 plaintiff Roudon William de   594496 594496 Roudon, William de, of Warsop, parson 0
4627728 2239600 2239600 defendant Coteller Roger   594496 594496 Coteller, Roger, of Warsop 3
4662959 2249878 2249878 defendant Masseham Robert yeoman 594496 594496 Masseham, Robert, of Warsop, yeoman 0
4662960 2249878 2249878 defendant Peresson John husbandman 594496 594496 Peresson, John, of Warsop, husbandman 1
4662961 2249878 2249878 defendant Brunneslay John husbandman 594496 594496 Brunneslay, John, of Warsop, husbandman 2
4662963 2249879 2249879 defendant Masseham Robert yeoman 594496 594496 Masseham, Robert, of Warsop, yeoman 0
4662964 2249879 2249879 defendant Peresson John husbandman 594496 594496 Peresson, John, of Warsop, husbandman 1
4662965 2249879 2249879 defendant Brunneslay John husbandman 594496 594496 Brunneslay, John, of Warsop, husbandman 2
4691113 2262740 2262740 defendant Suker Thomas chapman 594496 594496 Suker, Thomas, of Warsop, chapman 0
4712272 2269153 2269153 defendant Gaytclyf Thomas de yeoman 594496 594496 Gaytclyf, Thomas de, of Warsop, yeoman 0
4712274 2269153 2269153 defendant Shawe John yeoman 594496 594496 Shawe, John, of Warsop, yeoman 2
4746616 2279501 2279501 plaintiff Couper Thomas chaplain 594496 594496 Couper, Thomas, of Warsop, chaplain 1
4784180 2291051 2291051 plaintiff del Kechyn alias Parker Richard parker 594496 594496 del Kechyn alias Parker, Richard, of Warsop, parker 0
4813677 2300386 2300386 plaintiff Holand John   594496 594496 Holand, John, of Warsop, parson 0
4833506 2306486 2306486 plaintiff Clerk Thomas   594496 594496 Clerk, Thomas, of Warsop 0
4849662 2311372 2311372 defendant Spycer Richard fishmonger 594496 594496 Spycer, Richard, of Warsop, fishmonger 1
4889881 2323624 2323624 defendant Stokkes Roger draper 594496 594496 Stokkes, Roger, of Warsop, draper 0
4889882 2323624 2323624 defendant Dawes Thomas husbandman 594496 594496 Dawes, Thomas, of Warsop, husbandman 1
4894171 2324870 2324870 defendant Clerk Thomas yeoman 594496 594496 Clerk, Thomas, of Warsop, yeoman 3
4991526 2354350 2354350 defendant Barlee William miller 594496 594496 Barlee, William, of Warsop, miller 0
4991527 2354350 2354350 defendant Barlee Robert   594496 594496 Barlee, Robert, of Warsop, servant 1
5070691 2377730 2377730 defendant Stokkys Beatrice widow 594496 594496 Stokkys, Beatrice, of Warsop, widow 0
5081645 2381018 2381018 defendant Spicer John, junior husbandman 594496 594496 Spicer, John, junior, of Warsop, husbandman 1
5081646 2381018 2381018 defendant Spicer Richard, senior fisher 594496 594496 Spicer, Richard, senior, of Warsop, fisher 2
5081647 2381018 2381018 defendant Spicer Richard, junior husbandman 594496 594496 Spicer, Richard, junior, of Warsop, husbandman 3
5085297 2382095 2382095 defendant Loke John clerk 594496 594496 Loke, John, of Warsop, clerk 3
5094909 2384925 2384925 defendant Spycer Richard fisher 594496 594496 Spycer, Richard, of Warsop, fisher 4
5123294 2393253 2393253 defendant Stokkes Robert draper 594496 594496 Stokkes, Robert, of Warsop, draper 1
5123295 2393253 2393253 defendant Stokkes Thomas draper 594496 594496 Stokkes, Thomas, of Warsop, draper 2
5280428 2439350 2439350 defendant Apley or Arley Robert husbandman 594496 594496 Apley or Arley, Robert, of Warsop, husbandman 2
5329688 2453948 2453948 defendant Barbour William   594496 594496 Barbour, William, of Warsop 1
5330368 2454158 2454158 defendant Whithed William tailor 594496 594496 Whithed, William, of Warsop, tailor 0
5350408 2460249 2460249 defendant Lylly Robert laborer 594496 594496 Lylly, Robert, of Warsop, laborer 3
5357218 2462318 2462318 defendant Bolton Richard yeoman 594496 594496 Bolton, Richard, of Warsop, yeoman 0
5376996 2468399 2468399 defendant Lynam Thomas husbandman 594496 594496 Lynam, Thomas, of Warsop, husbandman 0
5376997 2468399 2468399 defendant Waddersly William husbandman 594496 594496 Waddersly, William, of Warsop, husbandman 1
5522460 2511844 2511844 defendant Wolley William husbandman 594496 594496 Wolley, William, of Warsop, husbandman 0
5538222 2516439 2516439 defendant Stede John turner 594496 594496 Stede, John, of Warsop, turner 2
5577864 2528149 2528149 defendant Wylkynson Ralph yeoman 594496 594496 Wylkynson, Ralph, of Warsop, yeoman 0
5595336 2533488 2533488 defendant Peke John clerk 594496 594496 Peke, John, of Warsop, clerk 3
5598775 2534494 2534494 defendant Bride John gent 594496 594496 Bride, John, of Warsop, gent 0
5598776 2534494 2534494 defendant Bride Nicholas gent 594496 594496 Bride, Nicholas, of Warsop, gent 1
5598777 2534494 2534494 defendant Fernborn Ralph laborer 594496 594496 Fernborn, Ralph, of Warsop, laborer 2
5598778 2534494 2534494 defendant Smyth John laborer 594496 594496 Smyth, John, of Warsop, laborer 3
5610589 2547038 2547038 plaintiff Barker Robert   594496 594496 Barker, Robert, of Warsop, son of Nicholas 0
5620197 2550175 2550175 defendant Payn Thomas   594496 594496 Payn, Thomas, of Warsop 4
5632125 2554071 2554071 defendant Busby Richard butcher 594496 594496 Busby, Richard, of Warsop, butcher 2
5632126 2554071 2554071 defendant Spicer Richard butcher 594496 594496 Spicer, Richard, of Warsop, butcher 3

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