names

108 rows where place_id = 609708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679895 1919778 1919778 defendant Grene Hugh clothier 609708 609708 Grene, Hugh, of Manchester, clothier 2
3679899 1919779 1919779 defendant Grene Hugh clothier 609708 609708 Grene, Hugh, of Manchester, clothier 2
3748870 1941583 1941583 defendant Bexwike Thomas mercer 609708 609708 Bexwike, Thomas, of Manchester, mercer 0
3748873 1941584 1941584 defendant Bexwike Thomas mercer 609708 609708 Bexwike, Thomas, of Manchester, mercer 0
3778336 1950937 1950937 defendant Barker Thomas chapman 609708 609708 Barker, Thomas, of Manchester, chapman 2
3870716 1980450 1980450 defendant Fydler John, junior (legal representative) 609708 609708 Fydler, John, junior, of Manchester, executors of 1
3870717 1980450 1980450 defendant Howme James yeoman 609708 609708 (Howme, James, of Manchester, yeoman 2
3877880 1982845 1982845 defendant Hardware Thomas   609708 609708 Hardware, Thomas, of Manchester, "passynger", administrators of 0
3877882 1982845 1982845 defendant Hardware Ellen widow 609708 609708 Hardware, Ellen, of Manchester, widow 2
3883103 1984609 1984609 defendant Shelmerdyne John glover 609708 609708 Shelmerdyne, John, of Manchester, glover 1
3883104 1984609 1984609 defendant Bekke Thomas merchant 609708 609708 Bekke, Thomas, of Manchester, merchant 2
3883105 1984609 1984609 defendant Brownesworde Richard, senior yeoman 609708 609708 Brownesworde, Richard, senior, of Manchester, yeoman 3
3885488 1985403 1985403 plaintiff Becke Thomas merchant 609708 609708 Becke, Thomas, of Manchester, merchant 0
3918808 1996614 1996614 defendant Barlowe Richard chapman 609708 609708 Barlowe, Richard, of Manchester, chapman 4
3927454 1999528 1999528 defendant Brown Ralph merchant 609708 609708 Brown, Ralph, of Manchester, merchant 1
3927460 1999529 1999529 defendant Holland Adam draper 609708 609708 Holland, Adam, of Manchester, draper 1
3935974 2002349 2002349 plaintiff Lewys Thomas gent 609708 609708 Lewys, Thomas, of Manchester, gent 0
3937925 2003017 2003017 plaintiff Pendylton Francis merchant 609708 609708 Pendylton, Francis, of Manchester, merchant 0
3959877 2010547 2010547 plaintiff Sorocord Ralph mercer 609708 609708 Sorocord, Ralph, of Manchester, mercer 0
3962879 2011609 2011609 plaintiff Wilson Miles clothier 609708 609708 Wilson, Miles, of Manchester, clothier 0
3973774 2015400 2015400 defendant Ryll or Royle Edward yeoman 609708 609708 Ryll or Royle, Edward, of Manchester, yeoman 0
3973782 2015402 2015402 plaintiff Hall Elias   609708 609708 Hall, Elias, of Manchester, merchant, administrators of 0
3984505 2019215 2019215 defendant Byrche Robert chapman 609708 609708 Byrche, Robert, of Manchester, chapman 1
3989177 2020867 2020867 plaintiff Baildon Oswald merchant 609708 609708 Baildon, Oswald, of Manchester, merchant 0
3992774 2022167 2022167 plaintiff Byrche George   609708 609708 Byrche, George, of Manchester 0
3992776 2022168 2022168 plaintiff Byrche George mercer 609708 609708 Byrche, George, of Manchester, mercer 0
3996829 2023634 2023634 plaintiff Dodge Otwell draper 609708 609708 Dodge, Otwell, of Manchester, draper 0
3996831 2023635 2023635 plaintiff Dodge Otwell draper 609708 609708 Dodge, Otwell, of Manchester, draper 0
4002031 2025506 2025506 plaintiff Haughton John draper 609708 609708 Haughton, John, of Manchester, draper 0
4024379 2033397 2033397 defendant Batson Thomas tanner 609708 609708 Batson, Thomas, of Manchester, tanner 1
4024380 2033397 2033397 defendant Garnett John cutler 609708 609708 Garnett, John, of Manchester, cutler 2
4024381 2033398 2033398 plaintiff Birche George   609708 609708 Birche, George, of Manchester 0
4026442 2034100 2034100 defendant Batson Thomas tanner 609708 609708 Batson, Thomas, of Manchester, tanner 1
4026443 2034100 2034100 defendant Garnett John cutler 609708 609708 Garnett, John, of Manchester, cutler 2
4029904 2035339 2035339 plaintiff Dodge Otwell   609708 609708 Dodge, Otwell, of Manchester 0
4034312 2036940 2036940 defendant Costerdyng Elias shoemaker 609708 609708 Costerdyng, Elias, of Manchester, shoemaker 0
4053864 2043760 2043760 plaintiff Aspeshawe Richard tailor 609708 609708 Aspeshawe, Richard, of Manchester, tailor 0
4055517 2044365 2044365 plaintiff Birche George merchant 609708 609708 Birche, George, of Manchester, merchant 0
4057607 2045102 2045102 plaintiff Byrche George   609708 609708 Byrche, George, of Manchester 0
4057609 2045103 2045103 plaintiff Byrche George merchant 609708 609708 Byrche, George, of Manchester, merchant 0
4057611 2045104 2045104 plaintiff Byrche George merchant 609708 609708 Byrche, George, of Manchester, merchant 0
4065372 2047904 2047904 plaintiff Haughton Humphrey clothier 609708 609708 Haughton, Humphrey, of Manchester, clothier 0
4065375 2047904 2047904 defendant Chourton Ralph carrier 609708 609708 Chourton, Ralph, of Manchester, carrier 2
4067868 2048818 2048818 defendant Kenyon Hugh yeoman 609708 609708 Kenyon, Hugh, of Manchester, yeoman 1
4087915 2055968 2055968 plaintiff Byrche George mercer 609708 609708 Byrche, George, of Manchester, mercer 0
4087917 2055969 2055969 plaintiff Byrche George mercer 609708 609708 Byrche, George, of Manchester, mercer 0
4101899 2060989 2060989 defendant Prowdloffe George (legal representative) 609708 609708 Prowdloffe, George, of Manchester, chapman, executrix of 1
4101900 2060989 2060989 defendant Prowdloffe Elizabeth widow 609708 609708 Prowdloffe, Elizabeth, of Manchester, widow 2
4105302 2062176 2062176 defendant Baguley James gent 609708 609708 Baguley, James, of Manchester, gent 0
4137870 2073901 2073901 defendant Fox Richard, junior yeoman 609708 609708 Fox, Richard, junior, of Manchester, yeoman 1
4144426 2076213 2076213 defendant Potter George   609708 609708 Potter, George, of Manchester, Lancs. Chapman 1
4144427 2076213 2076213 defendant Potter Leonard clothworker 609708 609708 Potter, Leonard, of Manchester, clothworker 2
4183796 2089824 2089824 defendant Proudluffe George mercer 609708 609708 Proudluffe, George, of Manchester, mercer 0
4234969 2107781 2107781 defendant Glover Edward whitawer 609708 609708 Glover, Edward, of Manchester, whitawer 2
4254656 2114546 2114546 defendant Gee Thomas sherman 609708 609708 Gee, Thomas, of Manchester, sherman 1
4254657 2114546 2114546 defendant Unnesworth John tailor 609708 609708 Unnesworth, John, of Manchester, tailor 2
4254660 2114547 2114547 defendant Gee Thomas sherman 609708 609708 Gee, Thomas, of Manchester, sherman 1
4254661 2114547 2114547 defendant Unnesworth John tailor 609708 609708 Unnesworth, John, of Manchester, tailor 2
4254662 2114547 2114547 defendant Royle Thomas tanner 609708 609708 Royle, Thomas, of Manchester, tanner 3
4260409 2116448 2116448 defendant Sorocolde Ralph yeoman 609708 609708 Sorocolde, Ralph, of Manchester, yeoman 1
4260660 2116533 2116533 defendant Glover Robert yeoman 609708 609708 Glover, Robert, of Manchester, yeoman 1
4260662 2116533 2116533 defendant Rodley Adam yeoman 609708 609708 Rodley, Adam, of Manchester, yeoman 3
4266320 2118378 2118378 defendant Strangwayes Eleanor widow 609708 609708 Strangwayes, Eleanor, of Manchester, or of Strangwayes, Lancs, widow 0
4267835 2118876 2118876 defendant Platt Nicholas weaver 609708 609708 Platt, Nicholas, of Manchester, weaver 3
4271354 2119997 2119997 defendant Percyvall Roger sherman 609708 609708 Percyvall, Roger, of Manchester, sherman 1
4271537 2120061 2120061 defendant Buckley Robert Lancs, apothecary 609708 609708 Buckley Robert, of Manchester, Lancs, apothecary 0
4272113 2120237 2120237 defendant Lancashire James whitawer 609708 609708 Lancashire, James, of Manchester, laborer, whitawer 1
4295557 2128497 2128497 defendant Owen William yeoman 609708 609708 Owen, William, of Manchester, yeoman 1
4295558 2128497 2128497 defendant Romsden John yeoman 609708 609708 Romsden, John, of Manchester, yeoman 2
4295559 2128497 2128497 defendant Romsden Thomas yeoman 609708 609708 Romsden, Thomas, of Manchester, yeoman 3
4295563 2128498 2128498 defendant Traves Richard joiner 609708 609708 Traves, Richard, of Manchester, joiner 2
4295564 2128498 2128498 defendant Doson William tailor 609708 609708 Doson, William, of Manchester, tailor 3
4299191 2129808 2129808 defendant Hawes Ralph yeoman 609708 609708 Hawes, Ralph, of Manchester, yeoman 1
4299192 2129808 2129808 defendant Sorowcold Gilbert yeoman 609708 609708 Sorowcold, Gilbert, of Manchester, yeoman 2
4300066 2130120 2130120 defendant Chalcrosse Hamnet smith 609708 609708 Chalcrosse, Hamnet, of Manchester, smith 1
4300775 2130373 2130373 defendant Travis George chapman 609708 609708 Travis, George, of Manchester, chapman 1
4300776 2130373 2130373 defendant Birche George chapman 609708 609708 Birche, George, of Manchester, chapman 2
4317827 2136346 2136346 defendant Kyrke Peter tanner 609708 609708 Kyrke, Peter, of Manchester, tanner 0
4336044 2142342 2142342 defendant Radclyffe Alexander mercer 609708 609708 Radclyffe, Alexander, of Manchester, mercer 1
4344031 2145190 2145190 defendant Wilson John tailor 609708 609708 Wilson, John, of Manchester, tailor 3
4348100 2146582 2146582 defendant Clarke Brian stationer 609708 609708 Clarke, Brian, of Manchester, stationer 1
4348101 2146582 2146582 defendant Lestwitch Roger   609708 609708 Lestwitch, Roger, of Manchester, soap maker 2
4348102 2146582 2146582 defendant Gye Thomas smith 609708 609708 Gye, Thomas, of Manchester, smith 3
4349422 2147061 2147061 defendant Redman Christopher chapman 609708 609708 Redman, Christopher, of Manchester, chapman 3
4353568 2148471 2148471 defendant Briddocke Edward cutler 609708 609708 Briddocke, Edward, of Manchester, cutler 1
4355497 2149144 2149144 defendant Fox Richard dyer 609708 609708 Fox, Richard, of Manchester, dyer 1
4361623 2151318 2151318 defendant Kerke Peter tanner 609708 609708 Kerke, Peter, of Manchester, tanner 3
4398381 2164040 2164040 defendant Foxe Richard yeoman 609708 609708 Foxe, Richard, of Manchester, yeoman 0
4400611 2164795 2164795 defendant Goodyere Thomas draper 609708 609708 Goodyere, Thomas, of Manchester, draper 1
4500180 2200694 2200694 defendant Ulgrave Thomas   609708 609708 Ulgrave, Thomas, of Manchester 5
4643002 2244061 2244061 defendant Parker Thomas   609708 609708 Parker, Thomas, of Manchester 0
4702497 2266194 2266194 defendant Roweley Nicholas gent 609708 609708 Roweley, Nicholas, of Manchester, gent 0
4811512 2299710 2299710 defendant Riddyngges Hugh chapman 609708 609708 Riddyngges, Hugh, of Manchester, chapman 2
4811514 2299710 2299710 defendant Radclyf John yeoman 609708 609708 Radclyf, John, of Manchester, yeoman 4
4890977 2323916 2323916 plaintiff Oulegrefe Thomas dyer 609708 609708 Oulegrefe, Thomas, of Manchester, dyer 0
4940445 2339035 2339035 defendant Rudde Robert smith 609708 609708 Rudde, Robert, of Manchester, smith 1
4959770 2344887 2344887 defendant Rutter William gent 609708 609708 Rutter, William, of Manchester, gent 1
4971911 2348532 2348532 defendant de Sandeforth Geoffrey yeoman 609708 609708 de Sandeforth, Geoffrey, of Manchester, yeoman 2
5124525 2393635 2393635 defendant (illegible) Henry gent 609708 609708 ---, Henry, of Manchester, gent 1
5124526 2393635 2393635 defendant Hulme Thomas   609708 609708 Hulme, Thomas, of Manchester 2

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