names

269 rows where place_id = 587367

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591218 1864879 1864879 defendant Rychardson Edmund yeoman 587367 587367 Rychardson, Edmund, of Rothewell, yeoman 0
3593787 1865694 1865694 defendant Burdon Robert mercer 587367 587367 Burdon, Robert, of Rothewell, mercer 0
3599909 1867626 1867626 defendant Turnour John yeoman 587367 587367 Turnour, John, of Rothewell, yeoman 0
3653785 1911442 1911442 defendant Burdon Robert yeoman 587367 587367 Burdon, Robert, of Rothewell, yeoman 0
3677795 1919105 1919105 defendant Walle Thomas gent 587367 587367 Walle, Thomas, of Rothewell, gent 0
3678716 1919410 1919410 plaintiff Nixon Edward   587367 587367 Nixon, Edward, of Rothewell 0
3722567 1933318 1933318 defendant Grave Robert butcher 587367 587367 Grave, Robert, of Rothewell, butcher 3
3727484 1934872 1934872 defendant Nykson Edward yeoman 587367 587367 Nykson, Edward, of Rothewell, yeoman 0
3741811 1939304 1939304 defendant Nyxon Edward yeoman 587367 587367 Nyxon, Edward, of Rothewell, yeoman 1
3756329 1943945 1943945 defendant Nyxson Edward husbandman 587367 587367 Nyxson, Edward, of Rothewell, husbandman 1
3760561 1945305 1945305 defendant Norres Ralph clothier 587367 587367 Norres, Ralph, of Rothewell, clothier 0
3760570 1945305 1945305 defendant Jakson John laborer 587367 587367 Jakson, John, of Rothewell, laborer 9
3764832 1946667 1946667 defendant Nyxson Edward yeoman 587367 587367 Nyxson, Edward, of Rothewell, yeoman 0
3778057 1950851 1950851 defendant Nyxson Edward yeoman 587367 587367 Nyxson, Edward, of Rothewell, yeoman 0
3797787 1957206 1957206 defendant Gybson Thomas laborer 587367 587367 Gybson, Thomas, of Rothewell, laborer 1
3833021 1968249 1968249 defendant Burdon Henry yeoman 587367 587367 Burdon, Henry, of Rothewell, yeoman 0
3836976 1969473 1969473 defendant Forman Robert husbandman 587367 587367 Forman, Robert, of Rothewell, husbandman 0
3848802 1973210 1973210 defendant Burden Henry yeoman 587367 587367 Burden, Henry, of Rothewell, yeoman 0
3865483 1978673 1978673 defendant Nyxson Edward gent 587367 587367 Nyxson, Edward, of Rothewell, gent 0
3879792 1983496 1983496 plaintiff Nyxson Edward yeoman 587367 587367 Nyxson, Edward, of Rothewell, yeoman 0
3896417 1989007 1989007 defendant Robynson Robert husbandman 587367 587367 Robynson, Robert, of Rothewell, husbandman 2
3921173 1997433 1997433 defendant Dobson Nicholas carpenter 587367 587367 Dobson, Nicholas, of Rothewell, carpenter 0
3921175 1997434 1997434 defendant Dobson Nicholas carpenter 587367 587367 Dobson, Nicholas, of Rothewell, carpenter 0
4001418 2025285 2025285 plaintiff Hampden Richard gent 587367 587367 Hampden, Richard, of Rothewell, gent 0
4018452 2031332 2031332 defendant Grene Thomas yeoman 587367 587367 Grene, Thomas, of Rothewell, yeoman 0
4041425 2039423 2039423 defendant Burbage Nicholas yeoman 587367 587367 Burbage, Nicholas, of Rothewell, or of Stanwicke, Nhants, yeoman 0
4113438 2065081 2065081 defendant Busse James carrier 587367 587367 Busse, James, of Rothewell, carrier 0
4113440 2065081 2065081 defendant Norres Leonard carrier 587367 587367 Norres, Leonard, of Rothewell, carrier 2
4113445 2065082 2065082 defendant Byrtwysle William clothier 587367 587367 Byrtwysle, William, of Rothewell, clothier 2
4120854 2067746 2067746 defendant Walshe alias Dutchman William yeoman 587367 587367 Walshe alias Dutchman, William, of Rothewell, yeoman 0
4120855 2067746 2067746 defendant Hall Francis yeoman 587367 587367 Hall, Francis, of Rothewell, yeoman 1
4120856 2067746 2067746 defendant Russell James husbandman 587367 587367 Russell, James, of Rothewell, husbandman 2
4120857 2067746 2067746 defendant Sore Vincent clerk 587367 587367 Sore, Vincent, of Rothewell, clerk 3
4187004 2090948 2090948 defendant Grene John, junior husbandman 587367 587367 Grene, John, junior, of Rothewell, husbandman 1
4233665 2107297 2107297 defendant Steven William husbandman 587367 587367 Steven, William, of Rothewell, husbandman 0
4240142 2109673 2109673 defendant Mayne William (legal representative) 587367 587367 Mayne, William, of Rothewell, yeoman, butcher, executor of 0
4240143 2109673 2109673 defendant Mayne Libius yeoman 587367 587367 Mayne, Libius, of Rothewell, yeoman 1
4432400 2174911 2174911 defendant Vyncent Robert   587367 587367 Vyncent, Robert, of Rothewell 0
4432404 2174912 2174912 defendant Vyncent Robert   587367 587367 Vyncent, Robert, of Rothewell 0
4445785 2183623 2183623 defendant Wagge Nicholas   587367 587367 Wagge, Nicholas, of Rothewell 0
4448993 2184628 2184628 defendant Warre Nicholas   587367 587367 Warre, Nicholas, of Rothewell 0
4450110 2184993 2184993 defendant Germethorp John de   587367 587367 Germethorp, John de, of Rothewell, parson 0
4452069 2185634 2185634 plaintiff Hyperom Thomas   587367 587367 Hyperom, Thomas, of Rothewell 0
4461410 2188651 2188651 defendant Denyas William   587367 587367 Denyas, William, of Rothewell 0
4462630 2189007 2189007 plaintiff Tery Robert   587367 587367 Tery, Robert, of Rothewell 0
4462632 2189008 2189008 plaintiff Tery Robert   587367 587367 Tery, Robert, of Rothewell 0
4475306 2192960 2192960 plaintiff Maydenwell William   587367 587367 Maydenwell, William, of Rothewell, on his own account 1
4485502 2196172 2196172 plaintiff Rasour John   587367 587367 Rasour, John, of Rothewell, on his own account 0
4495099 2199156 2199156 plaintiff Burdon Henry   587367 587367 Burdon, Henry, of Rothewell 0
4497337 2199814 2199814 plaintiff Dexter John   587367 587367 Dexter, John, of Rothewell 0
4508051 2202989 2202989 defendant Chapman John   587367 587367 Chapman, John, of Rothewell 0
4522443 2207359 2207359 plaintiff Grene Nicholas de   587367 587367 Grene, Nicholas de, of Rothewell, vicar 0
4535701 2211445 2211445 defendant Chapman John   587367 587367 Chapman, John, of Rothewell 0
4539262 2212536 2212536 plaintiff Vyncent John   587367 587367 Vyncent, John, of Rothewell 0
4550554 2216115 2216115 plaintiff Dawes John   587367 587367 Dawes, John, of Rothewell 0
4551205 2216319 2216319 defendant Chapeleyn Hugh   587367 587367 Chapeleyn, Hugh, of Rothewell 2
4558284 2218533 2218533 defendant Triklove John   587367 587367 Triklove, John, of Rothewell 1
4558285 2218533 2218533 defendant Chapman John   587367 587367 Chapman, John, of Rothewell 2
4558287 2218534 2218534 defendant Staunford Richard   587367 587367 Staunford, Richard, of Rothewell 0
4559315 2218865 2218865 plaintiff Maydewell wiliam   587367 587367 Maydewell, wiliam, of Rothewell 0
4559516 2218926 2218926 defendant Chapeleyn Hugh   587367 587367 Chapeleyn, Hugh, of Rothewell 0
4562365 2219790 2219790 defendant Draper Robert   587367 587367 Draper, Robert, of Rothewell 5
4562367 2219790 2219790 defendant Shethere John   587367 587367 Shethere, John, of Rothewell 7
4568679 2221786 2221786 plaintiff Walkere William (legal representative) 587367 587367 Walkere, William, of Rothewell, executrix of 0
4568961 2221878 2221878 defendant Chapelleyn Hugh   587367 587367 Chapelleyn, Hugh, of Rothewell 0
4608886 2233882 2233882 defendant Rasour John   587367 587367 Rasour, John, of Rothewell 0
4609184 2233977 2233977 defendant Barker William   587367 587367 Barker, William, of Rothewell 0
4623809 2238421 2238421 defendant Bradley William de tailor 587367 587367 Bradley, William de, of Rothewell, tailor 2
4630768 2240516 2240516 defendant Bykeleswade John   587367 587367 Bykeleswade, John, of Rothewell 1
4631862 2240848 2240848 defendant Turvey John   587367 587367 Turvey, John, of Rothewell 0
4640368 2243297 2243297 defendant Chapleyn Hugh   587367 587367 Chapleyn, Hugh, of Rothewell 1
4646151 2244947 2244947 defendant Draper Joan   587367 587367 Draper, Joan, of Rothewell 0
4646152 2244947 2244947 defendant Draper Thomas   587367 587367 Draper, Thomas, of Rothewell, son of Joan Draper 1
4652341 2246684 2246684 defendant Magge Thomas cordwainer 587367 587367 Magge, Thomas, of Rothewell, cordwainer 0
4657078 2248106 2248106 defendant Burdon Thomas   587367 587367 Burdon, Thomas, of Rothewell, bailiff 0
4660816 2249207 2249207 defendant Andrewe Richard gent 587367 587367 Andrewe, Richard, of Rothewell, gent 0
4664338 2250328 2250328 defendant Coryour Thomas chapman 587367 587367 Coryour, Thomas, of Rothewell, chapman 0
4667100 2255444 2255444 defendant Coke Robert husbandman 587367 587367 Coke, Robert, of Rothewell, husbandman 0
4667101 2255444 2255444 defendant Raleffes John husbandman 587367 587367 Raleffes, John, of Rothewell, husbandman 1
4667102 2255444 2255444 defendant Clerk John husbandman 587367 587367 Clerk, John, of Rothewell, husbandman 2
4669167 2256062 2256062 defendant Chapeleyn Hugh butcher 587367 587367 Chapeleyn, Hugh, of Rothewell, butcher 2
4670250 2256402 2256402 defendant shether Adam shether 587367 587367 shether, Adam, of Rothewell, shether 1
4672682 2257099 2257099 defendant Coryour Thomas chapman 587367 587367 Coryour, Thomas, of Rothewell, chapman 0
4673929 2257462 2257462 defendant Fekenham Alexander yeoman 587367 587367 Fekenham, Alexander, of Rothewell, yeoman 0
4681419 2259810 2259810 defendant Burdon Thomas   587367 587367 Burdon, Thomas, of Rothewell, bailiff 0
4683602 2260474 2260474 defendant Drapers Thomas draper 587367 587367 Drapers, Thomas, of Rothewell, draper 0
4688123 2261854 2261854 defendant Sutton Walter hosier 587367 587367 Sutton, Walter, of Rothewell, hosier 2
4691743 2262950 2262950 defendant Round Thomas draper 587367 587367 Round, Thomas, of Rothewell, draper 0
4696045 2264249 2264249 defendant Shether Adamm husbandman 587367 587367 Shether, Adamm, of Rothewell, husbandman 0
4700360 2265527 2265527 defendant Bryme Rober yeoman 587367 587367 Bryme, Rober, of Rothewell, yeoman 3
4700669 2265614 2265614 defendant Langton William husbandman 587367 587367 Langton, William, of Rothewell, husbandman 1
4700677 2265615 2265615 defendant Laughton William husbandman 587367 587367 Laughton, William, of Rothewell, husbandman 1
4706924 2267545 2267545 defendant Myssenden John husbandman 587367 587367 Myssenden, John, of Rothewell, husbandman 0
4707015 2267576 2267576 defendant Chapeleyn Hugh butcher 587367 587367 Chapeleyn, Hugh, of Rothewell, butcher 0
4709482 2268320 2268320 defendant Drapere Thomas draper 587367 587367 Drapere, Thomas, of Rothewell, draper 0
4721935 2272192 2272192 defendant Cros John husbandman 587367 587367 Cros, John, of Rothewell, husbandman 0
4733888 2275783 2275783 defendant Laghton William ironmonger 587367 587367 Laghton, William, of Rothewell, ironmonger 0
4733889 2275783 2275783 defendant Pulter Richard skinner 587367 587367 Pulter, Richard, of Rothewell, skinner 1
4745519 2279200 2279200 defendant Coriour Thomas baker 587367 587367 Coriour, Thomas, of Rothewell, baker 0
4754878 2281904 2281904 defendant Cartere Thomas husbandman 587367 587367 Cartere, Thomas, of Rothewell, husbandman 0

Next page

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