names

99 rows where place_id = 588893

✎ 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
3595936 1866362 1866362 defendant Skynner Richard, junior tailor 588893 588893 Skynner, Richard, junior, of Ayssheberton, tailor 1
3598332 1867106 1867106 defendant Ferre John husbandman 588893 588893 Ferre, John, of Ayssheberton, husbandman 0
3601378 1868094 1868094 defendant Dabyll Henry tucker 588893 588893 Dabyll, Henry, of Ayssheberton, tucker 0
3610060 1870813 1870813 defendant Skynner Richard, junior husbandman 588893 588893 Skynner, Richard, junior, of Ayssheberton, husbandman 0
3612475 1871534 1871534 defendant Alford William cordwainer 588893 588893 Alford, William, of Ayssheberton, cordwainer 0
3651008 1910682 1910682 defendant Farewell John tailor 588893 588893 Farewell, John, of Ayssheberton, tailor 0
3663871 1914638 1914638 plaintiff Prediaux Thomas   588893 588893 Prediaux, Thomas, of Ayssheberton 0
3680611 1920017 1920017 defendant Ford John   588893 588893 Ford, John, of Ayssheberton 0
3686117 1921819 1921819 defendant Farewell alias Pitley Roger husbandman 588893 588893 Farewell alias Pitley, Roger, of Ayssheberton, husbandman 0
3689815 1922972 1922972 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3689818 1922973 1922973 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3689819 1922973 1922973 defendant Wyllyng John capper 588893 588893 Wyllyng, John, of Ayssheberton, capper 0
3689820 1922974 1922974 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3709299 1929206 1929206 defendant Ayssheley Robert tanner 588893 588893 Ayssheley, Robert, of Ayssheberton, tanner 0
3710210 1929508 1929508 defendant Taillour John baker 588893 588893 Taillour, John, of Ayssheberton, baker 0
3733947 1936865 1936865 defendant Farewell Roger husbandman 588893 588893 Farewell, Roger, of Ayssheberton, husbandman 0
3733949 1936866 1936866 defendant Farewell Roger husbandman 588893 588893 Farewell, Roger, of Ayssheberton, husbandman 0
3733964 1936871 1936871 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3747617 1941172 1941172 defendant Faremouth John husbandman 588893 588893 Faremouth, John, of Ayssheberton, husbandman 0
3747855 1941252 1941252 defendant Chubbe John husbandman 588893 588893 Chubbe, John, of Ayssheberton, husbandman 0
3761429 1945588 1945588 defendant Brigge John baker 588893 588893 Brigge, John, of Ayssheberton, baker 0
3761430 1945588 1945588 defendant Clyff William smith 588893 588893 Clyff, William, of Ayssheberton, smith 1
3796884 1956904 1956904 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3804038 1959183 1959183 defendant Ford John   588893 588893 Ford, John, of Ayssheberton 0
3804224 1959254 1959254 defendant Ford John   588893 588893 Ford, John, of Ayssheberton 0
3809591 1960886 1960886 defendant Grene William yeoman 588893 588893 Grene, William, of Ayssheberton, yeoman 0
3814139 1962325 1962325 defendant Wylkey alias Sadeler Margery widow 588893 588893 Wylkey alias Sadeler, Margery, of Ayssheberton, widow 0
3814140 1962325 1962325 defendant Wylkey John shoemaker 588893 588893 Wylkey, John, of Ayssheberton, shoemaker 1
3821211 1964528 1964528 defendant Taillour Richard husbandman 588893 588893 Taillour, Richard, of Ayssheberton, husbandman 0
3821212 1964528 1964528 defendant Veyse John yeoman 588893 588893 Veyse, John, of Ayssheberton, yeoman 1
3821213 1964528 1964528 defendant Debyll Richard butcher 588893 588893 Debyll, Richard, of Ayssheberton, butcher 2
3821214 1964528 1964528 defendant Godefelowe John mercer 588893 588893 Godefelowe, John, of Ayssheberton, mercer 3
3845668 1972191 1972191 plaintiff Ford John   588893 588893 Ford, John, of Ayssheberton 0
3853544 1974733 1974733 defendant Predyaux Thomas   588893 588893 Predyaux, Thomas, of Ayssheberton, franklin 0
3853562 1974740 1974740 defendant Predyaux Thomas   588893 588893 Predyaux, Thomas, of Ayssheberton, franklin 0
3857557 1975999 1975999 defendant Mathewe William tanner 588893 588893 Mathewe, William, of Ayssheberton, tanner 0
3861432 1977284 1977284 plaintiff Ford John gent 588893 588893 Ford, John, of Ayssheberton, gent 0
3864977 1978491 1978491 defendant Ayssherigge John tanner 588893 588893 Ayssherigge, John, of Ayssheberton, tanner 0
3867606 1979399 1979399 defendant Bullok William husbandman 588893 588893 Bullok, William, of Ayssheberton, husbandman 0
3875503 1982049 1982049 plaintiff Ford John gent 588893 588893 Ford, John, of Ayssheberton, gent 0
3886399 1985704 1985704 defendant Seyncler John esq 588893 588893 Seyncler, John, of Ayssheberton, esq 2
3886406 1985705 1985705 defendant Seyntclere John esq 588893 588893 Seyntclere, John, of Ayssheberton, esq 1
3895773 1988794 1988794 defendant Pruston John laborer 588893 588893 Pruston, John, of Ayssheberton, laborer 0
3904719 1991836 1991836 defendant Paty Richard husbandman 588893 588893 Paty, Richard, of Ayssheberton, husbandman 1
3904720 1991836 1991836 defendant Harrell John husbandman 588893 588893 Harrell, John, of Ayssheberton, husbandman 2
3921274 1997468 1997468 defendant Soper Thomas yeoman 588893 588893 Soper, Thomas, of Ayssheberton, yeoman 3
3921275 1997468 1997468 defendant Bylsford Alexander yeoman 588893 588893 Bylsford, Alexander, of Ayssheberton, yeoman 4
3921303 1997471 1997471 defendant Soper Thomas yeoman 588893 588893 Soper, Thomas, of Ayssheberton, yeoman 2
3921304 1997471 1997471 defendant Bylsford Alexander yeoman 588893 588893 Bylsford, Alexander, of Ayssheberton, yeoman 3
3949571 2006925 2006925 defendant Frende Alice widow 588893 588893 Frende, Alice, of Ayssheberton, widow 0
3949572 2006925 2006925 defendant Furse Joan widow 588893 588893 Furse, Joan, of Ayssheberton, widow 1
3949575 2006926 2006926 defendant Preston John   588893 588893 Preston, John, of Ayssheberton, groom 1
3949578 2006927 2006927 defendant Rowdon Edmund huysbandman 588893 588893 Rowdon, Edmund, of Ayssheberton, huysbandman 1
3949579 2006927 2006927 defendant Metheryll Henry weaver 588893 588893 Metheryll, Henry, of Ayssheberton, weaver 2
3949581 2006928 2006928 defendant Wythecombe Nicholas husbandman 588893 588893 Wythecombe, Nicholas, of Ayssheberton, husbandman 0
3950334 2007198 2007198 defendant Herell Robert husbandman 588893 588893 Herell, Robert, of Ayssheberton, husbandman 0
3973895 2015438 2015438 defendant Predyaux Robert gent 588893 588893 Predyaux, Robert, of Ayssheberton, gent 1
3987191 2020163 2020163 plaintiff Wyk Hugh gent 588893 588893 Wyk, Hugh, of Ayssheberton, gent 0
4011962 2029008 2029008 plaintiff Predyaux Robert   588893 588893 Predyaux, Robert, of Ayssheberton, gent, attorney of the bench 0
4042165 2039682 2039682 defendant Elys Lawrence merchant 588893 588893 Elys, Lawrence, of Ayssheberton, merchant 0
4073537 2050822 2050822 defendant Wylmett John husbandman 588893 588893 Wylmett, John, of Ayssheberton, husbandman 0
4073538 2050822 2050822 defendant Abraham Anthony husbandman 588893 588893 Abraham, Anthony, of Ayssheberton, husbandman 1
4205365 2097427 2097427 defendant Belford John niller 588893 588893 Belford, John, of Ayssheberton, niller 1
4205366 2097427 2097427 defendant Leyman John baker 588893 588893 Leyman, John, of Ayssheberton, baker 2
4567815 2221505 2221505 defendant Taillour Roger   588893 588893 Taillour, Roger, of Ayssheberton 0
5057417 2373787 2373787 defendant Skynner Robert ostler 588893 588893 Skynner, Robert, of Ayssheberton, ostler 0
5057418 2373787 2373787 defendant Cone or Cove Robert tailor 588893 588893 Cone or Cove, Robert, of Ayssheberton, tailor 1
5075495 2379166 2379166 defendant Crokker Walter husbandman 588893 588893 Crokker, Walter, of Ayssheberton, husbandman 0
5113482 2390330 2390330 defendant Langdon Ambrose yeoman 588893 588893 Langdon, Ambrose, of Ayssheberton, yeoman 2
5142327 2398875 2398875 defendant More Simon   588893 588893 More, Simon, of Ayssheberton, brass worker 0
5171252 2407313 2407313 defendant Langdon Ambrose yeoman 588893 588893 Langdon, Ambrose, of Ayssheberton, yeoman 0
5222633 2422336 2422336 defendant Dolbeare William, junior gent 588893 588893 Dolbeare, William, junior, of Ayssheberton, gent 0
5222636 2422337 2422337 defendant Dolbeare William, junior gent 588893 588893 Dolbeare, William, junior, of Ayssheberton, gent 0
5259824 2433194 2433194 defendant Isshell Roger husbandman 588893 588893 Isshell, Roger, of Ayssheberton, husbandman 0
5268064 2435773 2435773 defendant Bonde Richard husbandman 588893 588893 Bonde, Richard, of Ayssheberton, husbandman 0
5268627 2435943 2435943 defendant Hoper John husbandman 588893 588893 Hoper, John, of Ayssheberton, husbandman 6
5309549 2447892 2447892 defendant Coke William barber 588893 588893 Coke, William, of Ayssheberton, barber 1
5317887 2450436 2450436 defendant Coupleston John husbandman 588893 588893 Coupleston, John, of Ayssheberton, husbandman 0
5319598 2450955 2450955 defendant Dobyll John yeoman 588893 588893 Dobyll, John, of Ayssheberton, yeoman 0
5320656 2451273 2451273 defendant Hoper Henry husbandman 588893 588893 Hoper, Henry, of Ayssheberton, husbandman 0
5320657 2451273 2451273 defendant Mathewe William husbandman 588893 588893 Mathewe, William, of Ayssheberton, husbandman 1
5363019 2464082 2464082 defendant Leche William yeoman 588893 588893 Leche, William, of Ayssheberton, yeoman 1
5367268 2465417 2465417 defendant Somer Thomas fuller of cloth 588893 588893 Somer, Thomas, of Ayssheberton, fuller of cloth 0
5367270 2465417 2465417 defendant Leche William husbandman 588893 588893 Leche, William, of Ayssheberton, husbandman 2
5370221 2466273 2466273 defendant Verneys John yeoman 588893 588893 Verneys, John, of Ayssheberton, yeoman 0
5370222 2466273 2466273 defendant Mayne John cordwainer 588893 588893 Mayne, John, of Ayssheberton, cordwainer 1
5402538 2475795 2475795 defendant Carpenter Walter   588893 588893 Carpenter, Walter, of Ayssheberton 0
5480204 2499062 2499062 defendant Storygge Robert husbandman 588893 588893 Storygge, Robert, of Ayssheberton, husbandman 0
5480205 2499062 2499062 defendant Leche William husbandman 588893 588893 Leche, William, of Ayssheberton, husbandman 1
5480206 2499062 2499062 defendant Wotton William husbandman 588893 588893 Wotton, William, of Ayssheberton, husbandman 2
5480207 2499062 2499062 defendant Mathewe William husbandman 588893 588893 Mathewe, William, of Ayssheberton, husbandman 3
5486696 2500922 2500922 defendant Prydeaux John yeoman 588893 588893 Prydeaux, John, of Ayssheberton, yeoman 0
5486697 2500922 2500922 defendant Brendon William yeoman 588893 588893 Brendon, William, of Ayssheberton, yeoman 1
5514098 2509258 2509258 defendant Flete John cordwainer 588893 588893 Flete, John, of Ayssheberton, cordwainer 0
5530731 2514129 2514129 defendant Bagtor Walter husbandman 588893 588893 Bagtor, Walter, of Ayssheberton, husbandman 3
5538708 2516588 2516588 defendant Dorset Margaret widow 588893 588893 Dorset, Margaret, of Ayssheberton, widow 0
5554480 2521348 2521348 defendant Debyll John butcher 588893 588893 Debyll, John, of Ayssheberton, butcher 0
5555839 2521699 2521699 defendant Carpenter Alice widow 588893 588893 Carpenter, Alice, of Ayssheberton, widow 0
5595189 2533459 2533459 defendant Denbold Thomas husbandman 588893 588893 Denbold, Thomas, of Ayssheberton, husbandman 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);