names

99 rows where place_id = 600402

✎ 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
3592197 1865177 1865177 defendant Cowelegh Richard   600402 600402 Cowelegh, Richard, of Kyngesbrigge, groom 1
3640897 1907596 1907596 defendant Lamb James merchant 600402 600402 Lamb, James, of Kyngesbrigge, merchant 0
3651968 1910961 1910961 defendant Beny Stephen weaver 600402 600402 Beny, Stephen, of Kyngesbrigge, weaver 0
3666188 1915372 1915372 defendant Gyllyngham William tailor 600402 600402 Gyllyngham, William, of Kyngesbrigge, tailor 0
3666189 1915372 1915372 defendant Briggeman William capper 600402 600402 Briggeman, William, of Kyngesbrigge, capper 1
3706724 1928388 1928388 defendant Renell or Revell Walter gent 600402 600402 Renell or Revell, Walter, of Kyngesbrigge, gent 0
3711411 1929873 1929873 defendant Lambe John merchant 600402 600402 Lambe, John, of Kyngesbrigge, merchant 1
3737728 1938022 1938022 defendant Clerke John weaver 600402 600402 Clerke, John, of Kyngesbrigge, weaver 0
3811995 1961659 1961659 defendant Lambe John merchant 600402 600402 Lambe, John, of Kyngesbrigge, merchant 0
3820437 1964275 1964275 defendant Mathewe Stephen merchant 600402 600402 Mathewe, Stephen, of Kyngesbrigge, merchant 0
3820438 1964275 1964275 defendant Gilbert William shoemaker 600402 600402 Gilbert, William, of Kyngesbrigge, shoemaker 1
3827227 1966381 1966381 defendant Waren John chaplain 600402 600402 Waren, John, of Kyngesbrigge, chaplain 2
3827228 1966382 1966382 plaintiff Bonfessor Andrew merchant 600402 600402 Bonfessor, Andrew, of Kyngesbrigge, merchant 0
3838351 1969915 1969915 plaintiff Toly Robert   600402 600402 Toly, Robert, of Kyngesbrigge 0
3843845 1971613 1971613 defendant Barnecote William smith 600402 600402 Barnecote, William, of Kyngesbrigge, smith 1
4445197 2183468 2183468 defendant Vela John   600402 600402 Vela, John, of Kyngesbrigge, son of Henry 9
4451883 2185567 2185567 plaintiff Hughe Matilda   600402 600402 Hughe, Matilda, of Kyngesbrigge, formerly wife of Stephen 0
4451884 2185567 2185567 defendant Suttere Robert   600402 600402 Suttere, Robert, of Kyngesbrigge 0
4455542 2186738 2186738 defendant Taillour Richard   600402 600402 Taillour, Richard, of Kyngesbrigge 2
4455547 2186739 2186739 defendant Taillour Richard   600402 600402 Taillour, Richard, of Kyngesbrigge 2
4464485 2189560 2189560 plaintiff Wasse John, senior   600402 600402 Wasse, John, senior, of Kyngesbrigge 0
4477471 2193619 2193619 defendant Brewere Edward   600402 600402 Brewere, Edward, of Kyngesbrigge 0
4512206 2204261 2204261 defendant Penda Henry   600402 600402 Penda, Henry, of Kyngesbrigge 4
4530893 2209953 2209953 defendant Northwode Alice   600402 600402 Northwode, Alice, of Kyngesbrigge 2
4583221 2226177 2226177 defendant Ridere John   600402 600402 Ridere, John, of Kyngesbrigge 0
4637771 2242587 2242587 defendant Ryder John   600402 600402 Ryder, John, of Kyngesbrigge 4
4637780 2242589 2242589 defendant Ryder John   600402 600402 Ryder, John, of Kyngesbrigge 4
4655964 2247743 2247743 defendant Dokenam Thomas butcher 600402 600402 Dokenam, Thomas, of Kyngesbrigge, butcher 2
4655965 2247743 2247743 defendant Haule or Hanle Henry butcher 600402 600402 Haule or Hanle, Henry, of Kyngesbrigge, butcher 3
4675198 2257855 2257855 defendant Stoce Henry laborer 600402 600402 Stoce, Henry, of Kyngesbrigge, laborer 1
4685490 2261056 2261056 defendant Stoce Henry laborer 600402 600402 Stoce, Henry, of Kyngesbrigge, laborer 1
4710582 2268667 2268667 defendant Hopere Robert laborer 600402 600402 Hopere, Robert, of Kyngesbrigge, laborer 1
4711417 2268901 2268901 defendant Cleford Stephen smith 600402 600402 Cleford, Stephen, of Kyngesbrigge, smith 0
4711716 2268987 2268987 defendant Castell Nicholas merchant 600402 600402 Castell, Nicholas, of Kyngesbrigge, merchant 0
4711717 2268987 2268987 defendant Malburgh William shipman 600402 600402 Malburgh, William, of Kyngesbrigge, shipman 1
4720533 2271759 2271759 defendant Pole Walter smith 600402 600402 Pole, Walter, of Kyngesbrigge, smith 1
4737410 2276816 2276816 defendant Toryng John merchant 600402 600402 Toryng, John, of Kyngesbrigge, merchant 1
4742108 2278184 2278184 defendant Whityng William husbandman 600402 600402 Whityng, William, of Kyngesbrigge, husbandman 0
4742109 2278184 2278184 defendant Mirefeld William husbandman 600402 600402 Mirefeld, William, of Kyngesbrigge, husbandman 1
4858572 2314056 2314056 plaintiff Brugge Walter   600402 600402 Brugge, Walter, of Kyngesbrigge 0
4862011 2315133 2315133 defendant Lynford John husbandman 600402 600402 Lynford, John, of Kyngesbrigge, husbandman 1
4870336 2317698 2317698 defendant Tredelond William laborer 600402 600402 Tredelond, William, of Kyngesbrigge, laborer 1
4876851 2319730 2319730 defendant Olyver Thomas tailor 600402 600402 Olyver, Thomas, of Kyngesbrigge, tailor 0
4888024 2323059 2323059 defendant Gille Thomas gent 600402 600402 Gille, Thomas, of Kyngesbrigge, gent 1
4902101 2327266 2327266 defendant Brugge Walter yeoman 600402 600402 Brugge, Walter, of Kyngesbrigge, yeoman 0
4922372 2333409 2333409 defendant Maleburgh John butcher 600402 600402 Maleburgh, John, of Kyngesbrigge, butcher 0
4922373 2333409 2333409 defendant Pocok John sheer man 600402 600402 Pocok, John, of Kyngesbrigge, sheer man 1
4922375 2333409 2333409 defendant Legh Walter glover 600402 600402 Legh, Walter, of Kyngesbrigge, glover 3
4926128 2334599 2334599 defendant Maleburgh John butcher 600402 600402 Maleburgh, John, of Kyngesbrigge, butcher 0
4926129 2334599 2334599 defendant Pocok John sheer man 600402 600402 Pocok, John, of Kyngesbrigge, sheer man 1
4926131 2334599 2334599 defendant Legh Walter glover 600402 600402 Legh, Walter, of Kyngesbrigge, glover 3
4937259 2338018 2338018 defendant Olyver Thomas merchant 600402 600402 Olyver, Thomas, of Kyngesbrigge, merchant 2
4947834 2341304 2341304 defendant Vele John husbandman 600402 600402 Vele, John, of Kyngesbrigge, husbandman 1
5010061 2359811 2359811 defendant Bell Rolland yeoman 600402 600402 Bell, Rolland, of Kyngesbrigge, yeoman 1
5060437 2374701 2374701 defendant Dillyk John husbandman 600402 600402 Dillyk, John, of Kyngesbrigge, husbandman 1
5060445 2374702 2374702 defendant Honyford Richard husbandman 600402 600402 Honyford, Richard, of Kyngesbrigge, husbandman 4
5082602 2381303 2381303 defendant Warberton John, senior merchant 600402 600402 Warberton, John, senior, of Kyngesbrigge, merchant 0
5122708 2393076 2393076 defendant Rogger Robert yeoman 600402 600402 Rogger, Robert, of Kyngesbrigge, yeoman 0
5233394 2425358 2425358 defendant Burley Thomas gent 600402 600402 Burley, Thomas, of Kyngesbrigge, gent 0
5237717 2426617 2426617 defendant Marlburgh John yeoman 600402 600402 Marlburgh, John, of Kyngesbrigge, yeoman 0
5260392 2433378 2433378 defendant Bigklegh Richard smith 600402 600402 Bigklegh, Richard, of Kyngesbrigge, smith 0
5260394 2433379 2433379 defendant Bigklegh Richard smith 600402 600402 Bigklegh, Richard, of Kyngesbrigge, smith 0
5261559 2433726 2433726 defendant Stephyn Richard scrivener 600402 600402 Stephyn, Richard, of Kyngesbrigge, scrivener 0
5263759 2434418 2434418 defendant Fayrefote David weaver 600402 600402 Fayrefote, David, of Kyngesbrigge, weaver 1
5281200 2439577 2439577 defendant Shynner Robert merchant 600402 600402 Shynner, Robert, of Kyngesbrigge, merchant 0
5293811 2443154 2443154 defendant Warberton John, junior merchant 600402 600402 Warberton, John, junior, of Kyngesbrigge, merchant 0
5297462 2444260 2444260 defendant Colyn John   600402 600402 Colyn, John, of Kyngesbrigge 0
5334350 2455345 2455345 plaintiff Eye or Gye Robert merchant 600402 600402 Eye or Gye, Robert, of Kyngesbrigge, merchant 0
5366568 2465197 2465197 defendant Carswyll Andrew merchant 600402 600402 Carswyll, Andrew, of Kyngesbrigge, merchant 0
5366571 2465197 2465197 defendant Eye Robert husbandman 600402 600402 Eye, Robert, of Kyngesbrigge, husbandman 3
5375887 2468050 2468050 defendant Rowe John   600402 600402 Rowe, John, of Kyngesbrigge, shoe maker 0
5398717 2474698 2474698 defendant Serle John laborer 600402 600402 Serle, John, of Kyngesbrigge, laborer 0
5406104 2476821 2476821 defendant Spycer William yeoman 600402 600402 Spycer, William, of Kyngesbrigge, yeoman 1
5410450 2478072 2478072 defendant Roger John weaver 600402 600402 Roger, John, of Kyngesbrigge, weaver 0
5419168 2480660 2480660 defendant Spycer William yeoman 600402 600402 Spycer, William, of Kyngesbrigge, yeoman 0
5424716 2482351 2482351 defendant Roigger John weaver 600402 600402 Roigger, John, of Kyngesbrigge, weaver 0
5455759 2491621 2491621 defendant Stonewyll John yeoman 600402 600402 Stonewyll, John, of Kyngesbrigge, yeoman 4
5457176 2492043 2492043 defendant Serle John husbandman 600402 600402 Serle, John, of Kyngesbrigge, husbandman 0
5467395 2495192 2495192 defendant Costard Andrew yeoman 600402 600402 Costard, Andrew, of Kyngesbrigge, yeoman 1
5467396 2495192 2495192 defendant Assheley Henry (legal representative) 600402 600402 Assheley, Henry, of Kyngesbrigge, mercer, executors of 2
5467578 2495230 2495230 defendant Stonewell John yeoman 600402 600402 Stonewell, John, of Kyngesbrigge, yeoman 2
5469045 2495669 2495669 defendant Serle John husbandman 600402 600402 Serle, John, of Kyngesbrigge, husbandman 0
5469056 2495672 2495672 defendant Lideston Geoffrey laborer 600402 600402 Lideston, Geoffrey, of Kyngesbrigge, laborer 3
5478677 2498649 2498649 defendant Costard Andrew yeoman 600402 600402 Costard, Andrew, of Kyngesbrigge, yeoman 0
5480701 2499190 2499190 defendant Carswyll Andrew yeoman 600402 600402 Carswyll, Andrew, of Kyngesbrigge, yeoman 0
5481537 2499406 2499406 defendant Lambe James merchant 600402 600402 Lambe, James, of Kyngesbrigge, merchant 0
5492507 2502671 2502671 defendant Corset John cordwainer 600402 600402 Corset, John, of Kyngesbrigge, cordwainer 0
5510807 2508223 2508223 defendant Judde John yeoman 600402 600402 Judde, John, of Kyngesbrigge, yeoman 2
5510808 2508223 2508223 defendant Mason John husbandman 600402 600402 Mason, John, of Kyngesbrigge, husbandman 3
5535098 2515507 2515507 defendant Oldesworthy Thomas merchant 600402 600402 Oldesworthy, Thomas, of Kyngesbrigge, merchant 0
5559078 2522617 2522617 defendant Horsewyll Simon yeoman 600402 600402 Horsewyll, Simon, of Kyngesbrigge, yeoman 0
5559080 2522618 2522618 defendant Horswyll Simon yeoman 600402 600402 Horswyll, Simon, of Kyngesbrigge, yeoman 0
5571989 2526350 2526350 defendant Bykley Nicholas smith 600402 600402 Bykley, Nicholas, of Kyngesbrigge, smith 1
5582595 2529623 2529623 defendant Lambe James merchant 600402 600402 Lambe, James, of Kyngesbrigge, merchant 0
5585169 2530430 2530430 defendant Notherell Robert yeoman 600402 600402 Notherell, Robert, of Kyngesbrigge, yeoman 0
5585170 2530430 2530430 defendant Rowe John cordwainer 600402 600402 Rowe, John, of Kyngesbrigge, cordwainer 1
5585171 2530430 2530430 defendant Flode John cordwainer 600402 600402 Flode, John, of Kyngesbrigge, cordwainer 2
5588435 2531388 2531388 defendant Lambe James merchant 600402 600402 Lambe, James, of Kyngesbrigge, merchant 0
5589841 2531808 2531808 defendant Benney Stephen weaver 600402 600402 Benney, Stephen, of Kyngesbrigge, weaver 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);