names

82 rows where place_id = 594543

✎ 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
3616537 1872808 1872808 defendant Turton Robert yeoman 594543 594543 Turton, Robert, of Tikhill, yeoman 3
3616547 1872810 1872810 defendant Turton Robert yeoman 594543 594543 Turton, Robert, of Tikhill, yeoman 3
3628009 1903615 1903615 defendant Snythall James husbandman 594543 594543 Snythall, James, of Tikhill, husbandman 0
3628015 1903616 1903616 defendant Snythall James husbandman 594543 594543 Snythall, James, of Tikhill, husbandman 0
3633100 1905164 1905164 defendant Bakes Robert tailor 594543 594543 Bakes, Robert, of Tikhill, tailor 0
3633101 1905164 1905164 defendant Mathewe Nicholas laborer 594543 594543 Mathewe, Nicholas, of Tikhill, laborer 1
3638936 1907001 1907001 defendant Turvyn Thomas husbandman 594543 594543 Turvyn, Thomas, of Tikhill, husbandman 0
3638937 1907001 1907001 defendant Bek Robert tailor 594543 594543 Bek, Robert, of Tikhill, tailor 1
3653873 1911475 1911475 defendant Ingram Mathew   594543 594543 Ingram, Mathew, of Tikhill 2
3692005 1923666 1923666 defendant Coke Robert shoemaker 594543 594543 Coke, Robert, of Tikhill, shoemaker 0
3699400 1926034 1926034 defendant Lawson Richard laborer 594543 594543 Lawson, Richard, of Tikhill, laborer 0
3791256 1955099 1955099 defendant Mallom John tailor 594543 594543 Mallom, John, of Tikhill, tailor 1
4414775 2169525 2169525 plaintiff Estfeld William de   594543 594543 Estfeld, William de, of Tikhill, son of Richard 0
4422607 2171928 2171928 plaintiff Estfeld William de   594543 594543 Estfeld, William de, of Tikhill, son of Richard de Tikhill, senior 0
4438994 2181491 2181491 plaintiff atte Well John   594543 594543 atte Well, John, of Tikhill 0
4453596 2186138 2186138 plaintiff Lescrop Richard master & warden of the castle chapel 594543 594543 Lescrop, Richard, of Tikhill, master & warden of the castle chapel 0
4453605 2186140 2186140 defendant -ynteworth John   594543 594543 -ynteworth, John, of Tikhill 2
4453612 2186141 2186141 defendant Wyntworth John   594543 594543 Wyntworth, John, of Tikhill 3
4462019 2188819 2188819 plaintiff Styrapps William (legal representative) 594543 594543 Styrapps, William, of Tikhill, executrix of 0
4462899 2189091 2189091 plaintiff Thwayt Thomas de   594543 594543 Thwayt, Thomas de, of Tikhill 0
4548967 2215609 2215609 plaintiff Dowell Thomas   594543 594543 Dowell, Thomas, of Tikhill 1
4564112 2220347 2220347 plaintiff Rypors Robert   594543 594543 Rypors, Robert, of Tikhill 0
4564113 2220347 2220347 defendant Craneby John (legal representative) 594543 594543 Craneby, John, of Tikhill, chaplain, executors of 0
4611582 2234685 2234685 defendant Bautre Thomas   594543 594543 Bautre, Thomas, of Tikhill 0
4631128 2240634 2240634 plaintiff Taillour Alice   594543 594543 Taillour, Alice, of Tikhill, formerly wife of John 0
4631129 2240634 2240634 defendant Wynteworth John   594543 594543 Wynteworth, John, of Tikhill 0
4650000 2246017 2246017 defendant Housley John   594543 594543 Housley, John, of tikhill 0
4650011 2246019 2246019 defendant Maltby William   594543 594543 Maltby, William, of tikhill 0
4654835 2247388 2247388 defendant Hesill John tanner 594543 594543 Hesill, John, of Tikhill, tanner 1
4659189 2248748 2248748 plaintiff Dawetre Thomas   594543 594543 Dawetre, Thomas, of Tikhill 0
4696113 2264267 2264267 defendant Bocher William butcher 594543 594543 Bocher, William, of Tikhill, butcher 0
4724060 2272821 2272821 defendant Dayville Rose   594543 594543 (Dayville, Rose, of Tikhill, formerly wife of Goscelin 1
4739908 2277559 2277559 defendant Tyas Peter husbandman 594543 594543 Tyas, Peter, of Tikhill, husbandman 0
4751842 2281032 2281032 defendant Buest William shoemaker 594543 594543 Buest, William, of Tikhill, shoemaker 0
4801225 2296567 2296567 defendant Ryse Richard dyer 594543 594543 Ryse, Richard, of Tikhill, dyer 0
4848264 2310928 2310928 defendant Barker Cecilia   594543 594543 Barker, Cecilia, of Tikhill 0
4851329 2311863 2311863 defendant Croseland John draper 594543 594543 Croseland, John, of Tikhill, draper 0
4855526 2313092 2313092 defendant Marche John shoemaker 594543 594543 Marche, John, of Tikhill, shoemaker 0
4855527 2313092 2313092 defendant Lofthoous John husbandman 594543 594543 Lofthoous, John, of Tikhill, husbandman 1
4855528 2313092 2313092 defendant Croslande John husbandman 594543 594543 Croslande, John, of Tikhill, husbandman 2
4855529 2313092 2313092 defendant Kilton John husbandman 594543 594543 Kilton, John, of Tikhill, husbandman 3
4875896 2319420 2319420 defendant Barker Cecily   594543 594543 Barker, Cecily, of Tikhill 0
4877104 2319807 2319807 defendant Twyer William barker 594543 594543 Twyer, William, of Tikhill, barker 0
4877105 2319807 2319807 defendant Saunderson Robert husbandman 594543 594543 Saunderson, Robert, of Tikhill, husbandman 1
4877106 2319807 2319807 defendant del Hall Hugh husbandman 594543 594543 del Hall, Hugh, of Tikhill, husbandman 2
4877107 2319807 2319807 defendant de Morte Mathew husbandman 594543 594543 de Morte, Mathew, of Tikhill, husbandman 3
4877108 2319807 2319807 defendant Holme Walter husbandman 594543 594543 Holme, Walter, of Tikhill, husbandman 4
4942686 2339683 2339683 defendant Barker Ralph   594543 594543 Barker, Ralph, of Tikhill, Yorksm barker 2
4942687 2339683 2339683 defendant Amcotes John walker 594543 594543 Amcotes, John, of Tikhill, walker 3
5007068 2358962 2358962 plaintiff Smyth Richard   594543 594543 Smyth, Richard, of Tikhill 0
5097628 2385733 2385733 defendant Coke John, junior yeoman 594543 594543 Coke, John, junior, of Tikhill, yeoman 0
5097629 2385733 2385733 defendant Bagshawe Robert yeoman 594543 594543 Bagshawe, Robert, of Tikhill, yeoman 1
5097630 2385733 2385733 defendant Wortley John husbandman 594543 594543 Wortley, John, of Tikhill, husbandman 2
5097631 2385733 2385733 defendant Rilay Henry husbandman 594543 594543 Rilay, Henry, of Tikhill, husbandman 3
5154062 2402347 2402347 defendant Triton John tanner 594543 594543 Triton, John, of Tikhill, tanner 0
5167645 2406260 2406260 defendant Coke John yeoman 594543 594543 Coke, John, of Tikhill, yeoman 1
5228094 2423822 2423822 defendant Cutson Cecily widow 594543 594543 Cutson, Cecily, of Tikhill, widow 0
5228095 2423822 2423822 defendant Heleby Thomas yeoman 594543 594543 Heleby, Thomas, of Tikhill, yeoman 1
5352572 2460901 2460901 defendant Helnby Thomas yeoman 594543 594543 Helnby, Thomas, of Tikhill, yeoman 0
5390567 2472366 2472366 defendant Hancok Ralph yeoman 594543 594543 Hancok, Ralph, of Tikhill, yeoman 1
5390568 2472366 2472366 defendant Heleby Alexander yeoman 594543 594543 Heleby, Alexander, of Tikhill, yeoman 2
5390569 2472366 2472366 defendant Kyng John yeoman 594543 594543 Kyng, John, of Tikhill, yeoman 3
5390570 2472366 2472366 defendant Kyng Robert yeoman 594543 594543 Kyng, Robert, of Tikhill, yeoman 4
5399111 2474815 2474815 defendant Hancok Ralph yeoman 594543 594543 Hancok, Ralph, of Tikhill, yeoman 1
5399112 2474815 2474815 defendant Heleby Alexander yeoman 594543 594543 Heleby, Alexander, of Tikhill, yeoman 2
5416559 2479870 2479870 defendant Hancok Ralph yeoman 594543 594543 Hancok, Ralph, of Tikhill, yeoman 1
5416561 2479870 2479870 defendant Kyng John yeoman 594543 594543 Kyng, John, of Tikhill, yeoman 3
5416562 2479870 2479870 defendant Kyng (illegible) yeoman 594543 594543 Kyng, _, of Tikhill, yeoman 4
5416725 2479922 2479922 defendant Hancok Ralph yeoman 594543 594543 Hancok, Ralph, of Tikhill, yeoman 1
5416726 2479922 2479922 defendant Heleby Alexander yeoman 594543 594543 Heleby, Alexander, of Tikhill, yeoman 2
5416727 2479922 2479922 defendant Kyng John yeoman 594543 594543 Kyng, John, of Tikhill, yeoman 3
5416728 2479922 2479922 defendant Kyng Robert yeoman 594543 594543 Kyng, Robert, of Tikhill, yeoman 4
5538766 2516609 2516609 defendant Lech Richard yeoman 594543 594543 Lech, Richard, of Tikhill, yeoman 0
5613860 2548113 2548113 plaintiff Derfold John de   594543 594543 Derfold, John de, of Tikhill, vicar 0
5613861 2548113 2548113 plaintiff Taillour Nicholas chaplain 594543 594543 Taillour, Nicholas, of Tikhill, chaplain 1
5613862 2548113 2548113 plaintiff Rypers Geoffrey chaplain 594543 594543 Rypers, Geoffrey, of Tikhill, chaplain 2
5615850 2548753 2548753 plaintiff Hallum Robert   594543 594543 Hallum, Robert, of Tikhill, son of John 0
5616613 2548999 2548999 defendant Strousall John   594543 594543 Strousall, John, of Tikhill 0
5620559 2550291 2550291 defendant Dadewell William de butcher 594543 594543 Dadewell, William de, of Tikhill, butcher 0
5620560 2550291 2550291 defendant Shophird Hugh butcher 594543 594543 Shophird, Hugh, of Tikhill, butcher 1
5620856 2550392 2550392 plaintiff Skynner Richard   594543 594543 Skynner, Richard, of Tikhill 0
5620858 2550392 2550392 defendant Broddesworth Richard   594543 594543 Broddesworth, Richard, of Tikhill 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);