names

72 rows where place_id = 587510

✎ 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
3591622 1864999 1864999 defendant Hanmer John innholder 587510 587510 Hanmer, John, of Toucestre, innholder 0
3596030 1866386 1866386 defendant Hanmer John innholder 587510 587510 Hanmer, John, of Toucestre, innholder 0
3596031 1866386 1866386 defendant Aportatyn Nicholas innholder 587510 587510 Aportatyn, Nicholas, of Toucestre, innholder 1
3604658 1869120 1869120 defendant Hammer John gent 587510 587510 Hammer, John, of Toucestre, gent 0
3604659 1869120 1869120 defendant Tounnesend John fishmonger 587510 587510 Tounnesend, John, of Toucestre, fishmonger 1
3604660 1869120 1869120 defendant Chery William ironmonger 587510 587510 Chery, William, of Toucestre, ironmonger 2
3618178 1873308 1873308 defendant Amylne John yeoman 587510 587510 Amylne, John, of Toucestre, yeoman 0
3634243 1905507 1905507 defendant Fosbery John cordwainer 587510 587510 Fosbery, John, of Toucestre, cordwainer 0
3634245 1905508 1905508 defendant Fosbery John cordwainer 587510 587510 Fosbery, John, of Toucestre, cordwainer 0
3635039 1905759 1905759 defendant Bullyvant William glover 587510 587510 Bullyvant, William, of Toucestre, glover 0
3635041 1905760 1905760 defendant Tydder Nicholas yeoman 587510 587510 Tydder, Nicholas, of Toucestre, yeoman 0
3635044 1905761 1905761 defendant Tydder Nicholas yeoman 587510 587510 Tydder, Nicholas, of Toucestre, yeoman 0
3635045 1905761 1905761 defendant Patenson John weaver 587510 587510 Patenson, John, of Toucestre, weaver 1
3635046 1905761 1905761 defendant Pratte Thomas tailor 587510 587510 Pratte, Thomas, of Toucestre, tailor 2
3635048 1905762 1905762 defendant Tydder Nicholas yeoman 587510 587510 Tydder, Nicholas, of Toucestre, yeoman 0
3635049 1905762 1905762 defendant Waterfall John laborer 587510 587510 Waterfall, John, of Toucestre, laborer 1
3635050 1905762 1905762 defendant Bentley John yeoman 587510 587510 Bentley, John, of Toucestre, yeoman 2
3635051 1905762 1905762 defendant Pratte Thomas tailor 587510 587510 Pratte, Thomas, of Toucestre, tailor 3
3637695 1906602 1906602 defendant Chaundeler John yeoman 587510 587510 Chaundeler, John, of Toucestre, yeoman 4
3639694 1907224 1907224 defendant Hay Peter husbandman 587510 587510 Hay, Peter, of Toucestre, husbandman 0
3746175 1940711 1940711 defendant Grene Richard yeoman 587510 587510 Grene, Richard, of Toucestre, yeoman 0
3822736 1965011 1965011 defendant Davy Benedict yeoman 587510 587510 Davy, Benedict, of Toucestre, yeoman 0
3848845 1973230 1973230 defendant Reynoldys William clerk 587510 587510 Reynoldys, William, of Toucestre, clerk 0
3887180 1985976 1985976 defendant Astwyk James tiler 587510 587510 Astwyk, James, of Toucestre, tiler 1
4429114 2173914 2173914 defendant Straunge John le   587510 587510 Straunge, John le, of Toucestre 0
4443292 2182864 2182864 plaintiff Carswell Thomas   587510 587510 Carswell, Thomas, of Toucestre 0
4444108 2183133 2183133 defendant Glovere William   587510 587510 Glovere, William, of Toucestre 0
4459923 2188160 2188160 plaintiff Scot John painter 587510 587510 Scot, John, of Toucestre, painter, on his own account 0
4460782 2188430 2188430 plaintiff Smyth Henry   587510 587510 Smyth, Henry, of Toucestre or Towcester 0
4496456 2199568 2199568 defendant Cook John   587510 587510 Cook, John, of Toucestre or Towcester 1
4506000 2202388 2202388 defendant Barewell Thomas   587510 587510 Barewell, Thomas, of Toucestre 1
4552296 2216673 2216673 defendant Saundres John   587510 587510 Saundres, John, of Toucestre 0
4562370 2219790 2219790 defendant Trusselove John baker 587510 587510 Trusselove, John, of Toucestre, baker 10
4653673 2247076 2247076 defendant Tyffeld Richard smith 587510 587510 Tyffeld, Richard, of Toucestre, smith 0
4655043 2247461 2247461 defendant Berell John ostler 587510 587510 Berell, John, of Toucestre, ostler 0
4669798 2256255 2256255 defendant Typpe John   587510 587510 Typpe, John, of Toucestre, parson 0
4671584 2256758 2256758 plaintiff Chacombe William   587510 587510 Chacombe, William, of Toucestre or Towcester 0
4681427 2259811 2259811 defendant Hertwell John   587510 587510 Hertwell, John, of Toucestre, bailiff 3
4681471 2259820 2259820 plaintiff Mortemer Laurence   587510 587510 Mortemer, Laurence, of Toucestre 1
4689216 2262186 2262186 plaintiff Tyffeld Richard   587510 587510 Tyffeld, Richard, of Toucestre or Towcester 0
4859757 2314419 2314419 defendant Duncote William yeoman 587510 587510 Duncote, William, of Toucestre, yeoman 0
4861714 2315034 2315034 defendant Procatour Robert husbandman 587510 587510 Procatour, Robert, of Toucestre, husbandman 2
4862847 2315364 2315364 defendant Clerk Richard husbandman 587510 587510 Clerk, Richard, of Toucestre, husbandman 1
4872939 2318491 2318491 defendant Clerk Thomas barber 587510 587510 Clerk, Thomas, of Toucestre, or of Silverston, barber 0
4872940 2318491 2318491 defendant Chapman Thomas husbandman 587510 587510 Chapman, Thomas, of Toucestre, husbandman 1
4879896 2320626 2320626 plaintiff Wale Robert   587510 587510 Wale, Robert, of Toucestre 0
4879897 2320626 2320626 defendant Burell John ostler 587510 587510 Burell, John, of Toucestre, ostler 0
4881525 2321124 2321124 defendant Machon Hugh butcher 587510 587510 Machon, Hugh, of Toucestre, butcher 0
4884557 2322077 2322077 plaintiff Wale Robert   587510 587510 Wale, Robert, of Toucestre 0
4893118 2324564 2324564 defendant Chaumberleyn William husbandman 587510 587510 Chaumberleyn, William, of Toucestre, husbandman 2
4899741 2326552 2326552 plaintiff Machon Agnes widow 587510 587510 Machon, Agnes, of Toucestre, widow 1
4902725 2327471 2327471 defendant Machon Ralph drover 587510 587510 Machon, Ralph, of Toucestre, drover 0
4918042 2332158 2332158 defendant Wyghton Eleanor widow 587510 587510 Wyghton, Eleanor, of Toucestre, widow 6
4941021 2339211 2339211 defendant Wale Robert gent 587510 587510 Wale, Robert, of Toucestre, gent 0
4982099 2351563 2351563 defendant Mydelyerde William tanner 587510 587510 Mydelyerde, William, of Toucestre, tanner 1
5032921 2366516 2366516 defendant Wale Robert gent 587510 587510 Wale, Robert, of Toucestre, gent 0
5032922 2366516 2366516 defendant Saundre Henry gent 587510 587510 Saundre, Henry, of Toucestre, gent 1
5085502 2382149 2382149 defendant Emson Peter gent 587510 587510 Emson, Peter, of Toucestre, gent 0
5095973 2385249 2385249 defendant Basynge John yeoman 587510 587510 Basynge, John, of Toucestre, yeoman 0
5263951 2434486 2434486 defendant Southworth Richard dyer 587510 587510 Southworth, Richard, of Toucestre, dyer 0
5289662 2441978 2441978 defendant Laurence Richard barker 587510 587510 Laurence, Richard, of Toucestre, barker 0
5289663 2441978 2441978 defendant Mey William barber 587510 587510 Mey, William, of Toucestre, barber 1
5316006 2449862 2449862 defendant Brewode John yeoman 587510 587510 Brewode, John, of Toucestre, yeoman 0
5325154 2452609 2452609 defendant Broun John spicer 587510 587510 Broun, John, of Toucestre, spicer 1
5416504 2479854 2479854 defendant Chese Henry tanner 587510 587510 Chese, Henry, of Toucestre, tanner 0
5440997 2487215 2487215 defendant Norton William yeoman 587510 587510 Norton, William, of Toucestre, yeoman 1
5441359 2487333 2487333 defendant Baxster Thomas yeoman 587510 587510 Baxster, Thomas, of Toucestre, yeoman 1
5496925 2504012 2504012 plaintiff Latymere Lawrence barber 587510 587510 Latymere, Lawrence, of Toucestre, barber 0
5496926 2504012 2504012 defendant Scot John, junior butcher 587510 587510 Scot, John, junior, of Toucestre, butcher 0
5541844 2517562 2517562 defendant Fesewyke Robert tailor 587510 587510 Fesewyke, Robert, of Toucestre, tailor 2
5574713 2527167 2527167 plaintiff Salesbury Henry innholder 587510 587510 Salesbury, Henry, of Toucestre, innholder 0
5575658 2527475 2527475 defendant Norton William yeoman 587510 587510 Norton, William, of Toucestre, yeoman 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);