names

94 rows where place_id = 596259

✎ 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
3623916 1875009 1875009 defendant Bowyer William yeoman 596259 596259 Bowyer, William, of Fulburn, yeoman 1
3623917 1875009 1875009 defendant Ware John yeoman 596259 596259 Ware, John, of Fulburn, yeoman 2
3625537 1875525 1875525 defendant Ware John yeoman 596259 596259 Ware, John, of Fulburn, yeoman 3
3635751 1905982 1905982 defendant Frogge John gent 596259 596259 Frogge, John, of Fulburn, gent 0
3635752 1905982 1905982 defendant Pratte William husbandman 596259 596259 Pratte, William, of Fulburn, husbandman 1
3695143 1924700 1924700 plaintiff Persey William husbandman 596259 596259 Persey, William, of Fulburn, husbandman 0
3767633 1947516 1947516 defendant Ball Richard pulter 596259 596259 Ball, Richard, of Fulburn, pulter 1
3776880 1950510 1950510 defendant Feverell John butcher 596259 596259 Feverell, John, of Fulburn, butcher 0
3778021 1950837 1950837 defendant Burges Robert husbandman 596259 596259 Burges, Robert, of Fulburn, husbandman 0
3811594 1961520 1961520 defendant Johnson Edmund   596259 596259 (Johnson, Edmund, of Fulburn, serving man 1
3839650 1970325 1970325 defendant Patrik Thomas husbandman 596259 596259 Patrik, Thomas, of Fulburn, husbandman 5
4514058 2204821 2204821 defendant Gobell John   596259 596259 Gobell, John, of Fulburn 1
4552586 2216761 2216761 defendant Godefray John   596259 596259 Godefray, John, of Fulburn 0
4552587 2216761 2216761 defendant Saunan Roger   596259 596259 Saunan, Roger, of Fulburn 1
4553058 2216899 2216899 defendant Mandon William   596259 596259 Mandon, William, of Fulburn 0
4564240 2220386 2220386 plaintiff Salle John chaplain 596259 596259 Salle, John, of Fulburn, chaplain 0
4564242 2220387 2220387 plaintiff Salle John chaplain 596259 596259 Salle, John, of Fulburn, chaplain 0
4609611 2234103 2234103 defendant Salman Robert   596259 596259 Salman, Robert, of Fulburn 0
4611991 2234811 2234811 defendant Assheby Robert   596259 596259 Assheby, Robert, of Fulburn 0
4611993 2234812 2234812 defendant Assheby Robert   596259 596259 Assheby, Robert, of Fulburn 0
4619019 2236942 2236942 defendant Tredegold John   596259 596259 Tredegold, John, of Fulburn 0
4633441 2241314 2241314 defendant Jekell Henry   596259 596259 Jekell, Henry, of Fulburn 2
4633447 2241315 2241315 defendant Jekell Henry   596259 596259 Jekell, Henry, of Fulburn 2
4658079 2248407 2248407 defendant Nethestrete John husbandman 596259 596259 Nethestrete, John, of Fulburn, husbandman 0
4658081 2248408 2248408 defendant Nethestrete John husbandman 596259 596259 Nethestrete, John, of Fulburn, husbandman 0
4690058 2262442 2262442 defendant Clement John tailor 596259 596259 Clement, John, of Fulburn, tailor 1
4692251 2263091 2263091 defendant Clement John tailor 596259 596259 Clement, John, of Fulburn, tailor 1
4712185 2269122 2269122 defendant Elys John laborer 596259 596259 Elys, John, of Fulburn, laborer 1
4713655 2269594 2269594 plaintiff Swetcok John   596259 596259 Swetcok, John, of Fulburn 0
4713886 2269668 2269668 defendant Grene Henry husbandman 596259 596259 Grene, Henry, of Fulburn, husbandman 0
4738023 2276994 2276994 defendant Joce Robert husbandman 596259 596259 Joce, Robert, of Fulburn, husbandman 1
4748998 2280191 2280191 defendant Sexteyn Richard butcher 596259 596259 Sexteyn, Richard, of Fulburn, butcher 1
4753190 2281381 2281381 defendant Clement John tailor 596259 596259 Clement, John, of Fulburn, tailor 6
4761065 2283812 2283812 defendant Ascheby Robert husbandman 596259 596259 Ascheby, Robert, of Fulburn, husbandman 0
4766652 2285561 2285561 defendant Jekel John husbandman 596259 596259 Jekel, John, of Fulburn, husbandman 0
4770360 2286700 2286700 defendant Astevy Robert husbandman 596259 596259 Astevy, Robert, of Fulburn, husbandman 0
4799245 2295941 2295941 defendant Gynde John dyer 596259 596259 Gynde, John, of Fulburn, dyer 1
4799246 2295941 2295941 defendant Gatesby John tailor 596259 596259 Gatesby, John, of Fulburn, tailor 2
4826261 2304247 2304247 defendant Bailly John   596259 596259 Bailly, John, of Fulburn, shepherd 0
4835337 2307048 2307048 defendant Fullburn William gent 596259 596259 Fullburn, William, of Fulburn, gent 0
4837328 2307617 2307617 defendant atte Wode William husbandman 596259 596259 atte Wode, William, of Fulburn, husbandman 0
4862721 2315325 2315325 defendant Fulburn William gent 596259 596259 Fulburn, William, of Fulburn, gent 0
4862723 2315326 2315326 defendant Fulburn William gent 596259 596259 Fulburn, William, of Fulburn, gent 0
4908470 2329202 2329202 defendant Ware Roger smith 596259 596259 Ware, Roger, of Fulburn, smith 1
4908471 2329202 2329202 defendant Blossum William husbandman 596259 596259 Blossum, William, of Fulburn, husbandman 2
4957308 2344148 2344148 defendant Gotesby John husbandman 596259 596259 Gotesby, John, of Fulburn, husbandman 1
5011912 2360336 2360336 plaintiff Wryghte Richard   596259 596259 Wryghte, Richard, of Fulburn 0
5011914 2360337 2360337 plaintiff Wryghte Richard   596259 596259 Wryghte, Richard, of Fulburn 0
5011916 2360338 2360338 plaintiff Wryghte Richard   596259 596259 Wryghte, Richard, of Fulburn 0
5116361 2391212 2391212 defendant Gissyng John husbandman 596259 596259 Gissyng, John, of Fulburn, husbandman 0
5116362 2391212 2391212 defendant Burgeys John husbandman 596259 596259 Burgeys, John, of Fulburn, husbandman 1
5116363 2391212 2391212 defendant Beell Robert husbandman 596259 596259 Beell, Robert, of Fulburn, husbandman 2
5154905 2402594 2402594 defendant Carawey Thomas husbandman 596259 596259 Carawey, Thomas, of Fulburn, husbandman 2
5171759 2407462 2407462 defendant Carewey Thomas husbandman 596259 596259 Carewey, Thomas, of Fulburn, husbandman 2
5184896 2411332 2411332 defendant Wyskyn Richard yeoman 596259 596259 Wyskyn, Richard, of Fulburn, yeoman 2
5184897 2411332 2411332 defendant Reson William yeoman 596259 596259 Reson, William, of Fulburn, yeoman 3
5187873 2412166 2412166 defendant Miller Roger miller 596259 596259 Miller, Roger, of Fulburn, miller 3
5190480 2412960 2412960 defendant Bardwey Thomas husbandman 596259 596259 Bardwey, Thomas, of Fulburn, husbandman 3
5204253 2416999 2416999 defendant Bowyer Michael yeoman 596259 596259 Bowyer, Michael, of Fulburn, yeoman 1
5206954 2417770 2417770 defendant Carawey Thomas husbandman 596259 596259 Carawey, Thomas, of Fulburn, husbandman 1
5228840 2424045 2424045 defendant Carewey Thomas chapman 596259 596259 Carewey, Thomas, of Fulburn, chapman 0
5228845 2424046 2424046 defendant Wryght Richard gent 596259 596259 Wryght, Richard, of Fulburn, gent 1
5228850 2424047 2424047 defendant Wryght Richard gent 596259 596259 Wryght, Richard, of Fulburn, gent 1
5235333 2425914 2425914 defendant Wright Richard gent 596259 596259 Wright, Richard, of Fulburn, gent 0
5235335 2425915 2425915 defendant Wright Richard gent 596259 596259 Wright, Richard, of Fulburn, gent 0
5250097 2430137 2430137 defendant Gate John husbandman 596259 596259 Gate, John, of Fulburn, husbandman 2
5263652 2434381 2434381 defendant Gessyng John husbandman 596259 596259 Gessyng, John, of Fulburn, husbandman 1
5263653 2434381 2434381 defendant Raysen William husbandman 596259 596259 Raysen, William, of Fulburn, husbandman 2
5263657 2434382 2434382 defendant Gessyng John husbandman 596259 596259 Gessyng, John, of Fulburn, husbandman 1
5263658 2434382 2434382 defendant Raysen William husbandman 596259 596259 Raysen, William, of Fulburn, husbandman 2
5278494 2438818 2438818 defendant Wryght Richard gent 596259 596259 Wryght, Richard, of Fulburn, gent 0
5278495 2438818 2438818 defendant Raysonn William gent 596259 596259 Raysonn, William, of Fulburn, gent 1
5278496 2438818 2438818 defendant Gessyng John husbandman 596259 596259 Gessyng, John, of Fulburn, husbandman 2
5278743 2438890 2438890 defendant Wryght Richard gent 596259 596259 Wryght, Richard, of Fulburn, gent 0
5278744 2438890 2438890 defendant Wryght John yeoman 596259 596259 Wryght, John, of Fulburn, yeoman 1
5282031 2439816 2439816 defendant Aleyn Henry (legal representative) 596259 596259 Aleyn, Henry, of Fulburn, administratrix of 0
5282032 2439816 2439816 defendant Aleyn Elizabeth widow 596259 596259 Aleyn, Elizabeth, of Fulburn, widow 1
5328108 2453476 2453476 defendant Bazer or Bayer John husbandman 596259 596259 Bazer or Bayer, John, of Fulburn, husbandman 0
5328110 2453477 2453477 defendant Bazer John husbandman 596259 596259 Bazer, John, of Fulburn, husbandman 0
5342680 2457911 2457911 defendant Jote John husbandman 596259 596259 Jote, John, of Fulburn, husbandman 2
5394529 2473495 2473495 defendant Smyth John maltman 596259 596259 Smyth, John, of Fulburn, maltman 1
5486718 2500928 2500928 defendant Exham William clerk 596259 596259 Exham, William, of Fulburn, clerk 0
5486719 2500928 2500928 defendant Kene William laborer 596259 596259 Kene, William, of Fulburn, laborer 1
5536726 2515972 2515972 defendant Smert John yeoman 596259 596259 Smert, John, of Fulburn, yeoman 0
5547542 2519298 2519298 defendant Atturclyffe Seth clerk 596259 596259 Atturclyffe, Seth, of Fulburn, clerk 0
5547564 2519307 2519307 defendant Ware John yeoman 596259 596259 Ware, John, of Fulburn, yeoman 0
5547565 2519307 2519307 defendant Bower William husbandman 596259 596259 Bower, William, of Fulburn, husbandman 1
5547566 2519307 2519307 defendant Pye Robert husbandman 596259 596259 Pye, Robert, of Fulburn, husbandman 2
5550680 2520225 2520225 defendant Smert John yeoman 596259 596259 Smert, John, of Fulburn, yeoman 3
5552842 2520882 2520882 defendant Smert John yeoman 596259 596259 Smert, John, of Fulburn, yeoman 0
5552843 2520882 2520882 defendant Persay John husbandman 596259 596259 Persay, John, of Fulburn, husbandman 1
5593890 2533078 2533078 defendant Stalleworth John, senior thatcher 596259 596259 Stalleworth, John, senior, of Fulburn, thatcher 0
5593891 2533078 2533078 defendant Stalleworth John, junior husbandman 596259 596259 Stalleworth, John, junior, of Fulburn, husbandman 1
5604883 2536395 2536395 defendant Smert John yeoman 596259 596259 Smert, John, of Fulburn, 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);