We have created a reference site with downloadable code examples to illustrate how you can use the ODATA API to retrieve our data from SQL Azure and display it on your website. You can find a link to the site at
http://www.lexisnexisstore.com/datamarket
Blogposts and Podcasts from the LexisNexis Online Communities ( http://www.lexisnexis.com/community/portal/ ) are now available through the Microsoft Azure DataMarket ( https://datamarket.azure.com/ ). The dataset includes LexisNexis and user generated content for a rolling six month period. This information is available at no cost through Azure DataMarket. This data may be displayed on your website as long as all LexisNexis branding remains in place and you agree to the terms and conditions of the LexisNexis Developer License Agreement.
DATA SET
The data set consists of "blogposts" and "podcasts" originally posted in the LexisNexis Communities. The previous six months of postings are included in the data yielding approximately 2500 blogposts and 500 podcasts on a variety of current legal topics. The data is contained in a single table accessible through Azure DataMarket. The table data is as follows:
| Data |
Description |
Notes |
| Id |
Unique Identity |
|
| Title |
Blog or Podcast Title |
|
| Link |
Link to the content online |
|
| MediaLink |
Link to podcast mp3 file |
|
| Extract |
Summary of the item |
First 150 characters of the item content |
| Content |
Full content of the item |
Entire content of the blogpost or podcast description |
| Author |
Author name |
|
| AuthorEmail |
Author email address |
|
| AuthorWeblink |
Author site url |
May be blank |
| DatePublished |
Date the item was published |
mm-dd-yyyy hh:mm:ss |
| ContentType |
Item type |
"blogpost" or "podcast" |
| CommunityName |
Community Long Name |
*** See below for listing |
| Keywords |
Tags |
|
| LexisID |
Permanent LexisID for the item |
Lexis identifier |
| CommunityAbbreviation |
Abbreviated Community Name |
*** See below for listing |
Data in RED can be queried.
ITEM TYPES
blogpost
podcast
COMMUNITY (LONG NAMES)
Corporate &
Securities Law Community
Legal Business Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Immigration Law COmmunity
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community
COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
workerscomp
realestate
elder
tax
international
immigration
patent
copyrighttrademark
litigationresources
environment
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment
SAMPLE QUERIES
select * from consumer.dbo.gmes_community_content where
charindex(‘blogpost’,item_type) > 0
select * from consumer.dbo.gmes_community_content where
community_shortname = ‘patentlaw’
VISUALIZATIONS
The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.
The following is an example of a typical blog post
