names

60 rows where place_id = 603070

✎ 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
3652955 1911254 1911254 defendant Morley William husbandman 603070 603070 Morley, William, of Claxby, husbandman 0
3652956 1911254 1911254 defendant Morley John husbandman 603070 603070 Morley, John, of Claxby, husbandman 1
3727752 1934949 1934949 defendant Morley Alan husbandman 603070 603070 Morley, Alan, of Claxby, husbandman 2
3729144 1935365 1935365 defendant Monson Thomas gent 603070 603070 Monson, Thomas, of Claxby, gent 0
3729156 1935367 1935367 defendant Monson Thomas gent 603070 603070 Monson, Thomas, of Claxby, gent 4
3754703 1943431 1943431 defendant Moreley William husbandman 603070 603070 Moreley, William, of Claxby, husbandman 3
3754704 1943431 1943431 defendant Moreley Alan husbandman 603070 603070 Moreley, Alan, of Claxby, husbandman 4
3767929 1947606 1947606 defendant Sotheby Richard laborer 603070 603070 Sotheby, Richard, of Claxby, laborer 0
3767930 1947606 1947606 defendant Morley Alan husbandman 603070 603070 Morley, Alan, of Claxby, husbandman 1
3850511 1973749 1973749 plaintiff Morelay Alan yeoman 603070 603070 Morelay, Alan, of Claxby, yeoman 0
3850512 1973749 1973749 plaintiff Odlyne John yeoman 603070 603070 Odlyne, John, of Claxby, yeoman 1
3894856 1988486 1988486 defendant Morelay John husbandman 603070 603070 Morelay, John, of Claxby, husbandman 0
3894857 1988486 1988486 defendant Morelay Hamond yeoman 603070 603070 Morelay, Hamond, of Claxby, yeoman 1
3907185 1992695 1992695 defendant Coke James husbandman 603070 603070 Coke, James, of Claxby, husbandman 0
3909451 1993461 1993461 plaintiff Smalney Richard yeoman 603070 603070 Smalney, Richard, of Claxby, yeoman 0
3972236 2014849 2014849 defendant Cherbery Thomas husbandman 603070 603070 Cherbery, Thomas, of Claxby, husbandman 1
4151203 2078544 2078544 defendant Morrcley John husbandman 603070 603070 Morrcley, John, of Claxby, husbandman 1
4168974 2084641 2084641 defendant Hanserd Giles gent 603070 603070 Hanserd, Giles, of Claxby, gent 1
4175672 2086961 2086961 defendant Covyle John yeoman 603070 603070 Covyle, John, of Claxby, yeoman 0
4175730 2086984 2086984 defendant Johnson John yeoman 603070 603070 Johnson, John, of Claxby, yeoman 0
4234623 2107656 2107656 defendant Fitzwilliams Augustine clerk 603070 603070 Fitzwilliams, Augustine, of Claxby Pluckaker, clerk 2
4243182 2110712 2110712 defendant Fitzwilliam Augustine clerk 603070 603070 Fitzwilliam, Augustine, of Claxby Pluckaker, clerk 2
4243187 2110713 2110713 defendant Fitzwilliam Augustine clerk 603070 603070 Fitzwilliam, Augustine, of Claxby Pluckaker, clerk 2
4247369 2112097 2112097 defendant Thorpe Robert esq 603070 603070 Thorpe, Robert, of Claxby, esq 0
4260946 2116622 2116622 defendant Thorpe Robert esq 603070 603070 Thorpe, Robert, of Claxby, esq 0
4260967 2116630 2116630 defendant Nottingham Nathaniel yeoman 603070 603070 Nottingham, Nathaniel, of Claxby, yeoman 1
4300413 2130249 2130249 defendant Morrlay John husbandman 603070 603070 Morrlay, John, of Claxby, husbandman 0
4452569 2185806 2185806 defendant Barker Robert   603070 603070 Barker, Robert, of Claxby 3
4462694 2189032 2189032 defendant Barkar Robert   603070 603070 Barkar, Robert, of Claxby 0
4464088 2189440 2189440 plaintiff Walkelyn John   603070 603070 Walkelyn, John, of Claxby 0
4542166 2213441 2213441 defendant Toutheby John   603070 603070 Toutheby, John, of Claxby, parson 0
4581880 2225779 2225779 defendant Wythernwyk Thomas   603070 603070 Wythernwyk, Thomas, of Claxby 0
4591927 2228828 2228828 defendant Daweson Richard   603070 603070 Daweson, Richard, of Claxby 0
4592055 2228870 2228870 defendant Hurt John   603070 603070 Hurt, John, of Claxby 0
4592056 2228870 2228870 defendant Clerk John   603070 603070 together with Clerk, John, of Claxby 1
4657111 2248118 2248118 defendant Dove William   603070 603070 Dove, William, of Claxby 3
4674707 2257700 2257700 defendant Dowse William husbandman 603070 603070 Dowse, William, of Claxby, husbandman 2
4682845 2260249 2260249 defendant Dowse William husbandman 603070 603070 Dowse, William, of Claxby, husbandman 2
4746326 2279421 2279421 defendant atte Tounesende Nicholas husbandman 603070 603070 atte Tounesende, Nicholas, of Claxby, husbandman 2
4841660 2308922 2308922 defendant Chapman John husbandman 603070 603070 Chapman, John, of Claxby, husbandman 2
4877371 2319876 2319876 defendant Batell Richard husbandman 603070 603070 Batell, Richard, of Claxby, husbandman 1
4936658 2337850 2337850 defendant Smyth John smith 603070 603070 Smyth, John, of Claxby, smith 2
4936659 2337850 2337850 defendant Mason Margaret widow 603070 603070 Mason, Margaret, of Claxby, widow 3
4937885 2338230 2338230 defendant Pynder William husbandman 603070 603070 Pynder, William, of Claxby Plukaker, husbandman 0
4940226 2338975 2338975 plaintiff Daye Thomas (legal representative) 603070 603070 Daye, Thomas, of Claxby, executors of 0
4940228 2338975 2338975 plaintiff Daweson Richard   603070 603070 Daweson, Richard, of Claxby 2
4940230 2338975 2338975 plaintiff Diconson Robert   603070 603070 Diconson, Robert, of Claxby 4
4972512 2348710 2348710 defendant Jamesson John husbandman 603070 603070 Jamesson, John, of Claxby, husbandman 0
5087560 2382742 2382742 defendant Dey Robert yeoman 603070 603070 Dey, Robert, of Claxby, yeoman 2
5096367 2385368 2385368 defendant Wythernwyk Richard esq 603070 603070 Wythernwyk, Richard, of Claxby, esq 0
5151993 2401718 2401718 defendant Sybsey John husbandman 603070 603070 Sybsey, John, of Claxby, husbandman 2
5187110 2411958 2411958 defendant Sybsey John husbandman 603070 603070 Sybsey, John, of Claxby, husbandman 2
5260156 2433302 2433302 defendant Proctour Henry   603070 603070 Proctour, Henry, of Claxby, franklin 0
5301350 2445357 2445357 defendant Wodirwyke William gent 603070 603070 Wodirwyke, William, of Claxby by Cayster, gent 0
5308360 2447536 2447536 defendant Dey Robert yeoman 603070 603070 Dey, Robert, of Claxby, yeoman 2
5547720 2519350 2519350 plaintiff Wryght Robert clerk 603070 603070 Wryght, Robert, of Claxby, clerk 0
5562602 2523665 2523665 plaintiff Wryght Robert clerk 603070 603070 Wryght, Robert, of Claxby, clerk 0
5572421 2526475 2526475 defendant Eston Richard husbandman 603070 603070 Eston, Richard, of Claxby, husbandman 1
5587432 2531086 2531086 defendant Craeke Thomas husbandman 603070 603070 Craeke, Thomas, of Claxby, husbandman 4
5626923 2552395 2552395 defendant Carwyk William husbandman 603070 603070 Carwyk, William, of Claxby, husbandman 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);