names

75 rows where place_id = 590203

✎ 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
3600218 1867715 1867715 defendant Chaweceys Henry butcher 590203 590203 Chaweceys, Henry, of Royston, Cams, butcher 0
3627413 1903429 1903429 defendant Marshall William (legal representative) 590203 590203 Marshall, William, of Royston, Cams, yeoman, administrator of 0
3761174 1945498 1945498 defendant Drawswerde Richard laborer 590203 590203 Drawswerde, Richard, of Royston, Cams, laborer 0
3807323 1960191 1960191 defendant Cole Robert innholder 590203 590203 Cole, Robert, of Royston, Cams, innholder 0
3846628 1972501 1972501 defendant Saywell John   590203 590203 Saywell, John, of Royston, Cams, yeoman, girdler, bailiff of Royston 0
3846654 1972508 1972508 defendant Saywell John   590203 590203 Saywell, John, of Royston, Cams, yeoman, girdler, bailiff of Royston 0
3893739 1988126 1988126 defendant Goldyng Robert chapman 590203 590203 Goldyng, Robert, of Royston, Cams, chapman 2
3912168 1994395 1994395 defendant Bradway Thomas smith 590203 590203 Bradway, Thomas, of Royston, Cams, smith 0
3923439 1998144 1998144 defendant Arthur Ralph husbandman 590203 590203 Arthur, Ralph, of Royston, Cams, husbandman 0
3951409 2007555 2007555 defendant Whythede Thomasine widow 590203 590203 Whythede, Thomasine, of Royston, Cams, widow 0
3956638 2009386 2009386 defendant Clerke Alexander yeoman 590203 590203 Clerke, Alexander, of Royston, Cams, yeoman 0
3967830 2013380 2013380 defendant Greneakers Henry innholder 590203 590203 Greneakers, Henry, of Royston, Cams, innholder 0
3967832 2013381 2013381 defendant Greneakers Henry innholder 590203 590203 Greneakers, Henry, of Royston, Cams, innholder 0
3977071 2016549 2016549 defendant Greneakers Henry innholder 590203 590203 Greneakers, Henry, of Royston, Cams, innholder 0
3977073 2016550 2016550 defendant Greneakers Henry gent 590203 590203 Greneakers, Henry, of Royston, Cams, innholder, gent 0
4021581 2032446 2032446 defendant Lamkyn Gilbert innholder 590203 590203 Lamkyn, Gilbert, of Royston, Cams, innholder 0
4042704 2039868 2039868 plaintiff Paynter Thomas maltster 590203 590203 Paynter, Thomas, of Royston, Cams, maltster 0
4166432 2083761 2083761 defendant Burdall William chapman 590203 590203 Burdall, William, of Royston, Cams, chapman 0
4173700 2086256 2086256 defendant Dyer Alexander gent 590203 590203 Dyer, Alexander, of Royston, Cams, gent 0
4176235 2087164 2087164 defendant Hedlinge Edmund yeoman 590203 590203 Hedlinge, Edmund, of Royston, Cams, yeoman 0
4184395 2090044 2090044 defendant Edlynge Edward innholder 590203 590203 Edlynge, Edward, of Royston, Cams, innholder 0
4197765 2094772 2094772 defendant Addams Thomas smith 590203 590203 Addams, Thomas, of Royston, Cams, smith 3
4215914 2101064 2101064 defendant Turnor Edmund husbandman 590203 590203 Turnor, Edmund, of Royston, Cams, husbandman 0
4225270 2104306 2104306 defendant Turnor Edmund husbandman 590203 590203 Turnor, Edmund, of Royston, Cams, husbandman 0
4230642 2106214 2106214 defendant Lynge John maltster 590203 590203 Lynge, John, of Royston, Cams, yeoman, maltster 0
4239588 2109474 2109474 defendant Coppyn Robert husbandman 590203 590203 Coppyn, Robert, of Royston, Cams, husbandman 0
4249655 2112869 2112869 defendant Turner Edward fishmonger 590203 590203 Turner, Edward, of Royston, Cams, fishmonger 2
4264063 2117633 2117633 defendant Turnor Edward fishmonger 590203 590203 Turnor, Edward, of Royston, Cams, fishmonger 2
4328941 2139991 2139991 defendant Turnor Anne spinster 590203 590203 Turnor, Anne, of Royston, Cams, spinster 3
4357372 2149806 2149806 defendant Mote Edward chapman 590203 590203 Mote, Edward, of Royston, Cams, chapman 0
4656613 2247961 2247961 defendant Plegge Richard chapman 590203 590203 Plegge, Richard, of Royston, Cams, chapman 0
4656615 2247962 2247962 defendant Plegge Richard chapman 590203 590203 Plegge, Richard, of Royston, Cams, chapman 0
4658792 2248622 2248622 defendant Grey Robert husbandman 590203 590203 Grey, Robert, of Royston, Cams, husbandman 0
4660436 2249090 2249090 defendant Person Hugh fisher 590203 590203 Person, Hugh, of Royston, Cams, fisher 1
4856367 2313366 2313366 defendant Jankyn Alexander butcher 590203 590203 Jankyn, Alexander, of Royston, Cams, butcher 0
4863525 2315562 2315562 defendant Wilwes or Wilowes William fisher 590203 590203 Wilwes or Wilowes, William, of Royston, Cams, fisher 0
4872665 2318401 2318401 defendant Meleman Thomas husbandman 590203 590203 Meleman, Thomas, of Royston, Cams, husbandman 0
4902176 2327292 2327292 defendant Heynes Thomas drover 590203 590203 Heynes, Thomas, of Royston, Cams, drover 1
4948416 2341486 2341486 defendant Cooke Richard husbandman 590203 590203 Cooke, Richard, of Royston, Cams, husbandman 1
4970709 2348180 2348180 defendant Baker Peter ostler 590203 590203 Baker, Peter, of Royston, Cams, ostler 1
4980530 2351116 2351116 defendant Norman Robert husbandman 590203 590203 Norman, Robert, of Royston, Cams, husbandman 2
5015257 2361344 2361344 defendant Baker John yeoman 590203 590203 Baker, John, of Royston, Cams, yeoman 2
5027217 2364830 2364830 defendant Oterburne John hosteler 590203 590203 Oterburne, John, of Royston, Cams, hosteler 0
5086281 2382379 2382379 defendant Smyth John ostler 590203 590203 Smyth, John, of Royston, Cams, ostler 0
5091054 2383778 2383778 defendant Smyth John ostler 590203 590203 Smyth, John, of Royston, Cams, ostler 0
5093160 2384390 2384390 defendant Smyth John husbandman 590203 590203 Smyth, John, of Royston, Cams, husbandman 3
5099116 2386169 2386169 defendant Coke Richard ostler 590203 590203 Coke, Richard, of Royston, Cams, ostler 1
5211863 2419207 2419207 defendant Seman John husbandman 590203 590203 Seman, John, of Royston, Cams,husbandman 3
5217123 2420748 2420748 defendant Wyllyam Thomas butcher 590203 590203 Wyllyam, Thomas, of Royston, Cams, butcher 0
5217968 2420989 2420989 defendant Seman John yeoman 590203 590203 Seman, John, of Royston, Cams, yeoman 1
5231732 2424850 2424850 defendant Gale Thomas tailor 590203 590203 Gale, Thomas, of Royston, Cams, tailor 1
5237142 2426446 2426446 defendant Smyth John butcher 590203 590203 Smyth, John, of Royston, Cams, butcher 4
5242126 2427899 2427899 defendant Stokton Thomas smith 590203 590203 Stokton, Thomas, of Royston, Cams, smith 0
5256927 2432295 2432295 defendant Bassyngburn Richard yeoman 590203 590203 Bassyngburn, Richard, of Royston, Cams, yeoman 0
5285501 2440778 2440778 defendant Clerke Nicholas drover 590203 590203 Clerke, Nicholas, of Royston, Cams, drover 4
5285508 2440779 2440779 defendant Clerke Nicholas drover 590203 590203 Clerke, Nicholas, of Royston, Cams, drover 4
5338324 2456562 2456562 defendant Basyngborne Richard yeoman 590203 590203 Basyngborne, Richard, of Royston, Cams, yeoman 0
5338327 2456563 2456563 defendant Basyngborne Richard yeoman 590203 590203 Basyngborne, Richard, of Royston, Cams, yeoman 0
5363734 2464311 2464311 defendant Stoughton Thomas smith 590203 590203 Stoughton, Thomas, of Royston, Cams, smith 0
5502314 2505648 2505648 defendant Marchall William yeoman 590203 590203 Marchall, William, of Royston, Cams, yeoman 0
5502317 2505649 2505649 defendant Marchall William yeoman 590203 590203 Marchall, William, of Royston, Cams, yeoman 1
5516599 2510019 2510019 defendant Chaunsy Henry butcher 590203 590203 Chaunsy, Henry, of Royston, Cams, butcher 2
5516612 2510023 2510023 defendant Chaunsy Henry butcher 590203 590203 Chaunsy, Henry, of Royston, Cams, butcher 3
5560159 2522935 2522935 defendant Marchall William yeoman 590203 590203 Marchall, William, of Royston, Cams, yeoman 0
5564697 2524258 2524258 defendant Marshall Robert mercer 590203 590203 Marshall, Robert, of Royston, Cams, mercer 2
5570497 2525944 2525944 defendant Boxsted John barber 590203 590203 Boxsted, John, of Royston, Cams, barber 0
5570500 2525945 2525945 defendant Boxsted John barber 590203 590203 Boxsted, John, of Royston, Cams, barber 0
5588865 2531528 2531528 defendant Cressewell Peter husbandman 590203 590203 Cressewell, Peter, of Royston, Cams, husbandman 0
5592739 2532725 2532725 defendant Nobell John innholder 590203 590203 Nobell, John, of Royston, Cams, innholder 1
5594583 2533285 2533285 defendant Clerk John yeoman 590203 590203 Clerk, John, of Royston, Cams, yeoman 1
5597110 2534003 2534003 defendant Marshall Robert yeoman 590203 590203 Marshall, Robert, of Royston, Cams, yeoman 2
5597119 2534005 2534005 defendant Marshall Robert yeoman 590203 590203 Marshall, Robert, of Royston, Cams, yeoman 1
5602219 2535591 2535591 defendant Clerke John innholder 590203 590203 Clerke, John, of Royston, Cams, innholder 4
5606126 2536808 2536808 defendant Nobyll John innholder 590203 590203 Nobyll, John, of Royston, Cams, innholder 0
5606852 2537032 2537032 defendant Nobyll John innholder 590203 590203 Nobyll, John, of Royston, Cams, innholder 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);