names

149 rows where place_id = 754947

✎ 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
4424299 2172442 2172442 defendant Graunger William   754947 754947 Graunger, William, of Yevele 0
4438154 2181233 2181233 plaintiff Andrewe John   754947 754947 Andrewe, John, of Yevele 0
4440109 2181834 2181834 plaintiff Bays Robert   754947 754947 Bays, Robert, of Yevele, vicar 0
4440110 2181835 2181835 plaintiff Bays Robert   754947 754947 Bays, Robert, of Yevele, vicar 0
4440112 2181836 2181836 plaintiff Bays Robert   754947 754947 Bays, Robert, of Yevele, vicar 0
4444375 2183230 2183230 defendant Burcy John   754947 754947 Burcy, John, of Yevele 7
4455587 2186755 2186755 defendant Bays Robert   754947 754947 Bays, Robert, of Yevele, vicar 0
4455589 2186756 2186756 defendant Bays Robert   754947 754947 Bays, Robert, of Yevele, vicar 0
4464590 2189595 2189595 plaintiff Webbe Henry   754947 754947 Webbe, Henry, of Yevele 0
4468566 2190838 2190838 plaintiff Beausscot John   754947 754947 Beausscot, John, of Yevele 0
4473546 2192384 2192384 defendant Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4475675 2193072 2193072 defendant Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4479040 2194101 2194101 defendant Glovere John   754947 754947 Glovere, John, of Yevele 3
4483250 2195461 2195461 defendant Bakere William   754947 754947 Bakere, William, of Yevele 1
4495025 2199134 2199134 defendant Baker John   754947 754947 Baker, John, of Yevele 0
4507272 2202743 2202743 defendant Shepherd Nicholas   754947 754947 Shepherd, Nicholas, of Yevele 0
4509982 2203607 2203607 plaintiff Bakere Peter   754947 754947 Bakere, Peter, of Yevele 0
4511237 2203961 2203961 plaintiff Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4511239 2203962 2203962 plaintiff Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4512866 2204454 2204454 plaintiff Brasyetere William   754947 754947 Brasyetere, William, of Yevele 0
4513954 2204786 2204786 plaintiff Burcy John   754947 754947 Burcy, John, of Yevele 0
4514744 2205028 2205028 defendant Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4515167 2205159 2205159 defendant Boutaillour John   754947 754947 Boutaillour, John, of Yevele 1
4515437 2205244 2205244 plaintiff Child John   754947 754947 Child, John, of Yevele 0
4515441 2205244 2205244 defendant Boucher William   754947 754947 Boucher, William, of Yevele 3
4518717 2206230 2206230 plaintiff Dougge or Dongge Robert   754947 754947 Dougge or Dongge, Robert, of Yevele 0
4522009 2207222 2207222 defendant Bedman John   754947 754947 Bedman, John, of Yevele 5
4524547 2208011 2208011 plaintiff Hoper Stephen   754947 754947 Hoper, Stephen, of Yevele 0
4524596 2208025 2208025 defendant Boutaillour John   754947 754947 Boutaillour, John, of Yevele 0
4524597 2208025 2208025 defendant Kemer John fishmonger 754947 754947 Kemer, John, of Yevele, fishmonger 1
4524674 2208053 2208053 plaintiff Bonefaunt Ralph   754947 754947 Bonefaunt, Ralph, of Yevele 1
4524677 2208054 2208054 plaintiff Bonefaunt Ralph   754947 754947 Bonefaunt, Ralph, of Yevele 1
4527465 2208870 2208870 plaintiff Loketone William   754947 754947 Loketone, William, of Yevele 0
4529632 2209548 2209548 plaintiff Mounfort William   754947 754947 Mounfort, William, of Yevele 0
4529633 2209548 2209548 defendant Hewyssh Thomas   754947 754947 Hewyssh, Thomas, of Yevele 0
4529634 2209548 2209548 defendant Tokevyle William tailor 754947 754947 Tokevyle, William, of Yevele, tailor 1
4531183 2210028 2210028 defendant Wyse Richard   754947 754947 Wyse, Richard, of Yevele 1
4532416 2210406 2210406 defendant Bury John   754947 754947 Bury, John, of Yevele 3
4535901 2211500 2211500 defendant Kemer John   754947 754947 Kemer, John, of Yevele 0
4535990 2211535 2211535 defendant Horsman Walter   754947 754947 Horsman, Walter, of Yevele 0
4537900 2212138 2212138 defendant Pelree Peter   754947 754947 Pelree, Peter, of Yevele 1
4541453 2213224 2213224 defendant Glovere John   754947 754947 Glovere, John, of Yevele 1
4541695 2213296 2213296 defendant Keymere John   754947 754947 Keymere, John, of Yevele 4
4542821 2213645 2213645 defendant Belman Henry   754947 754947 Belman, Henry, of Yevele 0
4543916 2214000 2214000 defendant Staunton John   754947 754947 Staunton, John, of Yevele 0
4543942 2214012 2214012 plaintiff Bakere John   754947 754947 Bakere, John, of Yevele 0
4543944 2214012 2214012 defendant Austyn John   754947 754947 Austyn, John, of Yevele 0
4545952 2214670 2214670 plaintiff Boutaillour John   754947 754947 Boutaillour, John, of Yevele 0
4549426 2215767 2215767 defendant Dyer John   754947 754947 Dyer, John, of Yevele 0
4551838 2216521 2216521 defendant Delman Henry   754947 754947 Delman, Henry, of Yevele 0
4556085 2217846 2217846 defendant Hosyer Walter   754947 754947 Hosyer, Walter, of Yevele 0
4556086 2217846 2217846 defendant Bryd Richard   754947 754947 Bryd, Richard, of Yevele 1
4556090 2217847 2217847 defendant Lambrok William   754947 754947 Lambrok, William, of Yevele 0
4556094 2217848 2217848 defendant Sele alias Tokevyle William tailor 754947 754947 Sele alias Tokevyle, William, of Yevele, tailor 0
4568022 2221567 2221567 defendant Webbe William   754947 754947 Webbe, William, of Yevele 2
4568078 2221584 2221584 plaintiff Trok John   754947 754947 Trok, John, of Yevele 0
4568079 2221584 2221584 defendant Glovere John fishmonger 754947 754947 Glovere, John, of Yevele, fishmonger 0
4580954 2225518 2225518 plaintiff Dogge Robert   754947 754947 Dogge, Robert, of Yevele 0
4580956 2225519 2225519 plaintiff Dogge Robert   754947 754947 Dogge, Robert, of Yevele 0
4581300 2225616 2225616 defendant Basset John   754947 754947 Basset, John, of Yevele 0
4581618 2225699 2225699 defendant Ryell John fuller 754947 754947 Ryell, John, of Yevele, fuller 3
4585095 2226759 2226759 defendant Boontaillour John   754947 754947 Boontaillour, John, of Yevele 0
4587056 2227360 2227360 defendant Stalbryge John   754947 754947 Stalbryge, John, of Yevele, formerly bailiff for Richard Boyton, formerly sheriff 0
4589151 2227986 2227986 defendant Frank John   754947 754947 Frank, John, of Yevele 0
4589152 2227986 2227986 defendant Boucher William   754947 754947 Boucher, William, of Yevele 1
4592730 2229067 2229067 defendant Sele William   754947 754947 Sele, William, of Yevele 1
4593135 2229162 2229162 defendant Taillour William   754947 754947 Taillour, William, of Yevele 1
4594891 2229656 2229656 defendant Lynwebbe William   754947 754947 Lynwebbe, William, of Yevele 0
4595935 2229983 2229983 defendant Erle John chapman 754947 754947 Erle, John, of Yevele, chapman 1
4596533 2230153 2230153 defendant Joye Richard   754947 754947 Joye, Richard, of Yevele 5
4596534 2230153 2230153 defendant Gilberd John   754947 754947 Gilberd, John, of Yevele 6
4597405 2230432 2230432 defendant Basset John   754947 754947 Basset, John, of Yevele 1
4598232 2230685 2230685 defendant Lane John   754947 754947 Lane, John, of Yevele 2
4608731 2233836 2233836 plaintiff Brasyeter William   754947 754947 Brasyeter, William, of Yevele 0
4610429 2234338 2234338 plaintiff Carse Richard   754947 754947 Carse, Richard, of Yevele 0
4611777 2234746 2234746 defendant Compton John   754947 754947 Compton, John, of Yevele 1
4614025 2235400 2235400 plaintiff Dogge Robert   754947 754947 Dogge, Robert, of Yevele 0
4614029 2235401 2235401 defendant Carse Richard   754947 754947 Carse, Richard, of Yevele 0
4614073 2235415 2235415 defendant Lygh William   754947 754947 Lygh, William, of Yevele 0
4614074 2235415 2235415 defendant Baker Benedict   754947 754947 Baker, Benedict, of Yevele 1
4614075 2235415 2235415 defendant Baker Gillian   754947 754947 Baker, Gillian, of Yevele 2
4614077 2235415 2235415 defendant Lane John   754947 754947 Lane, John, of Yevele 4
4617046 2236340 2236340 defendant Peek John   754947 754947 Peek, John, of Yevele 0
4619678 2237140 2237140 defendant Neuman Thomas   754947 754947 Neuman, Thomas, of Yevele 0
4620580 2237423 2237423 defendant Bardolf John   754947 754947 Bardolf, John, of Yevele 1
4623536 2238339 2238339 plaintiff Mewe John sadler 754947 754947 Mewe, John, of Yevele, sadler 0
4624128 2238524 2238524 defendant Gobette John tanner 754947 754947 Gobette, John, of Yevele, tanner 0
4627483 2239527 2239527 defendant Crokkere Robert   754947 754947 Crokkere, Robert, of Yevele 2
4628469 2239824 2239824 defendant Glover John fishmonger 754947 754947 Glover, John, of Yevele, fishmonger 6
4629659 2240198 2240198 defendant Evesham John (legal representative) 754947 754947 Evesham, John, of Yevele, dyer, executrix of 0
4650728 2246231 2246231 defendant Sele William   754947 754947 Sele, William, of Yevele 0
4652897 2246841 2246841 defendant Jakes Robert weaver 754947 754947 Jakes, Robert, of Yevele, weaver 0
4652900 2246841 2246841 defendant Langebroke William weaver 754947 754947 Langebroke, William, of Yevele, weaver 3
4653187 2246932 2246932 defendant Taillour James dyer 754947 754947 Taillour, James, of Yevele, dyer 1
4657734 2248303 2248303 defendant Mymon John taverner 754947 754947 Mymon, John, of Yevele, taverner 2
4660822 2249210 2249210 plaintiff Dogge Robert   754947 754947 Dogge, Robert, of Yevele 0
4660825 2249211 2249211 plaintiff Dogge Robert   754947 754947 Dogge, Robert, of Yevele 0
4660923 2249241 2249241 plaintiff Dougge or Dongge Robert   754947 754947 Dougge or Dongge, Robert, of Yevele 0
4663494 2250058 2250058 defendant Langbrok William dyer 754947 754947 Langbrok, William, of Yevele, dyer 0
4666091 2250861 2250861 defendant Deye John smith 754947 754947 Deye, John, of Yevele, smith 0

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